cannot-assign-the-macro-to-a-button-in-conditional-hw

Questions Archive › cannot-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

0 Vote Up Vote Down

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