Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I enter a list in a Combo box?
I'm trying to create a drop-down list in a combo box from the Control Box
toolbar, as I need to be able to play around with the font size, but I can't get it to work. Could someone please tell me where I'm going wrong? My sheet is called Purchaseorder. I've got a list of companies in cells A1 to A10 that I want to appear in a drop-down list. I've got an empty combo box open and now need to put in the data from cells A1 to A10. Having read a few replies to other people's questions about this subject, I'm still struggling to do it! I right click on the combo box and go to Properties, where I see a long list of options I can change. I go to ListFillRange and type in Purchaseorder!A1:A10. There isn't an OK button or anything, so I just close the Properties window. But nothing happens! I just can't get the data to go into the box. Can anyone help? It's driving me crazy! Thanks very much, KarenPF |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Be able to enter data ALSO in a COMBO BOX drop down | Excel Worksheet Functions | |||
Combo box or list box | Excel Discussion (Misc queries) | |||
How do to enter data in a combo box on a worksheet? | Excel Discussion (Misc queries) | |||
change 'alt+enter' combo to just 'enter' | Excel Discussion (Misc queries) | |||
enter value in a cell from a combo box | Excel Discussion (Misc queries) |