On the Control toolbox, click the Design mode button
Select the combo box
On the Control toolbox, click the Properties button
In the Properties window, for ListFillRange, type the name, or cell
references, of your input range.
Click the Exit Design Mode button.
abfabrob wrote:
Thank you for this.
However... when I click on format control, there is no where to input the
cell range.
My options a "size", "protection", "properties" and "web".
Rob
"Anthony Slater" wrote:
Ok, lets make it simpler
1. Fill sheet 1 A1:A5 with some data such as Apple, banana, pear, orange,
lemon
2. Draw combo box somewhere on sheet 1
3. right click on combox
4. format control
5. Input range will be A1:A5
6. Cell link will A10
Thats it.
When you click on the drop down, the list will show. Click on an item in the
list will change the value accordingly in cel A10
You can then use the value in cell A10 in another formula depending on what
you really need from the out come. Such as IF(a10=1,"APPLE","ANOTHER KIND OF
FRUIT")
Don't forget to check contextures.com for more help
"abfabrob" wrote:
I'm sorry, I really don't understand. Can you explain in more detail? I'm
really new to this. I don't know what you mean by naming the list (where/how
do I name it?). When I right click on the Combo box and go to format control,
I don't know where to input anything. And do I OLNY input "=mylist"? And
where do I input the fact that I want it to be in cell C10? (or whichever I
decide to use).
Hope you can help!
"Anthony Slater" wrote:
Assuming you want a combo box in sheet 1:
Make a list in sheet, lets say A1:A5. Name this list "mylist'
Draw your combo box in sheet one.
Right click on it and choose format control. the input range would be =mylist
the cell link will be anywhere you want (such as C10)
Depending on what you choose from the drop down, C10 will change accordingly.
HTH
For more help, check out contextures.com
"abfabrob" wrote:
I want to use a combo box as a drop down list. I know where to find the combo
box (in the control toolbox), but I have no idea how to populate it or
activate it...
Any help will be appriciated for this real novice
Rob.
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html