Refer to named SpinButton in VBA

[mjj300]

I have a SpinButton in my Excel worksheet (not on a form), that I have named "spinMonth". I have assigned a VBA macro called "spinMonthClick" to the SpinButton. In the macro I want to refer to the Value property of the SpinButton. How do I do that? I can refer to the SpinButton as a Shape using ActiveSheet.Shapes("spinMonth"), but this doesn't give me access to the Value property.

Thanks in advance.

[snb]

Either:

Please Login or Register  to view this content.

Or

Please Login or Register  to view this content.

Dependent of the kind of spinbutton (formcontrol or ActiveX)

[tmallin]

Snb,

I found your reply after a search of how to reference spinbuttons in VBA, but your suggestion is not working in my case. I have an ActiveX Spinbutton in Excel 2010, and this code in a module (not in the sheet where the spinbutton is located)

Please Login or Register  to view this content.

Executing this returns an "Object doesn't support this property or method" error.

Is there another way to change the max value of a spinbutton?

thanks

[jayesh25]

Try to go in Design mode, right click on the spin button and select properties you can manually change it's Min/Max - Unless it's macro based and you'd like it to be different everytime?

[protonLeah]

tmallin,
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

[tmallin]

OK, I'll post a new one. Just thought I'd try to cut down on the number of posts. thnx