YTLE#110: Excel Forms Scroll Bar Linked To Cell

[ExcelIsFun]

I am not sure. But no problem, try THE best Excel question site (with 1000s of true Excel masters):

mrexcel[dot]com/forum

[fordman32508]

This is close to what I'm looking for. I have a combo box with a range of so many values. Instead of returning a 0,1...,10,11. How can I change that to return specific values. Such and 0-3 would be a 0, 4 would be 30, and so on. I've tried embedded IFs, but the list grows and that isn't practical. Good series. I have to share this with friends.

[ExcelIsFun]

I am not sure. This is the site to ask Excel questions:

mrexcel[dot]com/forum

If you state a clear question with all the parameters, explain how data is set up, what your goal is and what the end result is, you should get an answer within 15 minutes.

[tirathmistry]

awesome tutorial of form tool bar thank you very much sir for putting very magical tutorial.

what is use of combo box,list box,check box,option button,spinner,button?????????

please help me sir.

[ExcelIsFun]

Dear tirathmistry,

They are all very similar to the Scroll bar. You should try each one and see what it does. The trick that will work for all them is to right-click and then "format control". You will then see that each one allows you to input a range of values (Max/Min or a list from some cells) and link the control to a cell. Really, if you know how to do the scroll, you know how to do the others.

--ExcelIsFun