Excel Spin box

How do I add a spin box in excel?
chobosAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
vbkidCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Office

From novice to tech pro — start learning today.