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
|