Spin32.ocx control tab not visible

  • Thread starter Thread starter Paul
  • Start date Start date
P

Paul

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
 
Back
Top