Questions Archivecannot-assign-the-macro-to-a-button-in-conditional-hw
Jingyu Zhao asked 2 years ago

When I want to select the macro to a button, the excel pops up a box with \”your formula is too complex to be assigned to object\”.  Does anyone know how to solve it? Thank you!  

1 Answers
Justis answered 2 years ago

Hi Jingyu, it’s hard to tell based off the limited info I have, but I’m guessing it may have something to do with where you’ve put your code. Do you have it in a module instead of the sheet code?

Your Answer

3 + 14 =