Excel Spin box

How do I add a spin box in excel?
chobosAsked:
Who is Participating?
 
vbkidConnect With a Mentor Commented:
chobos,
Another way is.
Select View/Toolbars/Forms. Select the Spinbutton from the new toolbar displyed and click on the excel sheet. Right click on this and select format control. On this select 'Control' and specify the Min,Max & Incremental values,Specify the cell where you want the result to be displayed in the cell link area. Click Ok. Click on the sheet and you are ready to use the spin button.Click up or down /left or right depending on how you place the spin button.

vbkid.
 
0
 
calacucciaCommented:
What's a spin box ???
0
 
mrt1Commented:
Do you mean a spin button?

From the menu, select View/Toolbars/Control Toolbox

The Control Toolbox should include the Spin Button. If it doesn't, you may be using the full installation of Excel.
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
chobosAuthor Commented:
Thanks vbkid

That's worked well but how do I incorporate this with Data/Validation/list?

Thanks

chobos
0
 
vbkidCommented:
chobos,
In the area D1 to D5 enter some values.
Place the Cursor at cell "A1" .
Select Data/Validation
In the displayed window click 'Allow' select the 'List' Option.
You get one more option 'Source' displayed. In the Source enter "D1:D5"
If you place the cursor on cell A1 You See a Dropdown. Click the down arrow you see the list of values from the D1 to D5

If any of these you had already implemented or if I am not upto your expectations please excuse me. If you want you can email any of your questions to me at exuser21@hotmail.com.

I am sorry for the delay.
bye,
vbkid
0
 
chobosAuthor Commented:
Thanks vbkid
0
 
vbkidCommented:
chobos,
Did it meet your requirements.

vbkid
0
 
chobosAuthor Commented:
Sorry, not quite.  See my email for an example.
0
All Courses

From novice to tech pro — start learning today.