RUN TIME ERROR '-2147024809

[TBZ120]

Hello,

I've been struggling with trying to make this code work. It keeps giving me an error no matter what.
I'm trying to make menu items clickable so they will show a different menu but everything I try to click one of these buttons (circled in red in the picture) the error comes up.
Anyone knows what the problem could be please?
Thanks

B2 is for when the "purchases" option is changed
MenuItem is the name of the buttons (ex: MenuItem1, MenuItem2 etc..)

 

[Ruddles]

Take the quotes off the variable MenuNumb: you're treating it as a string constant. I think it should be .Shapes("MenuItem" & MenuNum)

 

[TBZ120]

Thank you it worked!