ActiveX Spin Button LinkedCell Question

Right, AlKey is suggesting the same thing--looking at your question again, I am wondering if you have VBA code tied to this control. That particular error would not occur just because you're using a spin button tied to a cell. I suggest you attach the file.

There are lots of ways that error can occur but most likely you have code that refers to a worksheet that does not exist

Please Login or Register  to view this content.

or you have an array that you have exceeded the bounds

Please Login or Register  to view this content.

Thanks for the replies. When I type it in it disappears! Poof. gone. If I enter C6 from the same page, no issue. When I reference Sheet10 (which does exist) it doesn't want to take it. I typed in Sheet10!C6 and as soon as I hit enter it disappears. Like I entered nothing.

Spin Button.png

Alkey,


I am entering like that... See attached...


Spin Button.png

Hey Alkey,

I tired it on a totally new blank sheet. And the dam thing worked. So there is something between the two sheets preventing them from connecting (linking). None of the sheets are protected This is sooo weird. Thank you for trying to helping. Much appreciated.