I am running W2K Professional operating system with Office
XP. I have a spreadsheet that I am manipulating using the
Spinner ActiveX control (Spin32.ocx). However, when I
right click on the spinner and choose "Format Control" I
only have four tabs: Size, Protection, Properties, and
Web. I am missing the 5th tab "Control" which allows you
to choose the amounts that you want the Spinner to
manipulate the cell by. Does anyone know the reasons for
this? I can use VBA to acheive the desired result, but I
know that this functionality used to exist. Does anyone
know the answer?

Paul,

Right-click the control and choose Properties. There, change the
SmallScroll property. The spinner control from the Forms toolbar has the tab
you're thinking of.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Paul" wrote in message
...
I am running W2K Professional operating system with Office
XP. I have a spreadsheet that I am manipulating using the
Spinner ActiveX control (Spin32.ocx). However, when I
right click on the spinner and choose "Format Control" I
only have four tabs: Size, Protection, Properties, and
Web. I am missing the 5th tab "Control" which allows you
to choose the amounts that you want the Spinner to
manipulate the cell by. Does anyone know the reasons for
this? I can use VBA to acheive the desired result, but I
know that this functionality used to exist. Does anyone
know the answer?

Thanks, I was looking in the wrong place! This is exactly what I was
looking for.



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!