Need to determine the value of a form type spinner in VBA.

[OaklandJim]

Excel people

I honestly Googled this but could not find the answer. I have a form type spinner that calls a vba macro. In the macro I need to get the value of the spinner. PLease assist. Thanks for your help.

Jim

 

[OaklandJim]

I found the solution. Syntax example:

[Chart].Shapes("MoveUpOrDown_Spinner").ControlFormat.Value