Hi
This is going to be really simple but my mind has gone blank...
How do I reference a spin button from a variable that I set.
e.g
Code
Dim objSpn As Object
Dim y as Integer
Set objSpn = ActiveSheet.Shapes("spnWCDate")
y = objSpn.Value
This doesn't work, but hope it explains what I want. It's so I dont have to write the whole object name each time I reference it.
ADDED: I've just noticed that this doesn't work even i do reference the object with the full name. I copied this from a forms spin control that I was using, why can't i store the value of the spin button in a variable??
Cheers
Kev.