Using a combo box in an Excel form

X

xlcharlie

I'm experienced with Excel & VBA, but new to using Excel to create a form.

I would like to simply use a cell as a drop down. Not knowing if that is
possible, I have added a combo box to the spreasheet, but I am unclear how
the data entered/selected in the drop down will be stored. Is it stored as a
VB variable associated with the control or do I link the control to a cell to
store the data? To define the values in the drop down/combo box, do I have
to use cell references or can I write in the values in the properties
(writing them in hasn't worked for me)? Finally, what property do I have to
set for the combo box (ActiveX control) to automatically move & size with the
cell?

Direct answers, links to web sites, any help is greatly appreciated. Thanks
in advance.
 
J

JulieD

Hi

the easiest way to get a drop down in a cell is to use data / validation -
Debra Dalgleish has great notes on her site at
www.contextures.com/tiptech.html
... look for Data Validation - Basics and then all the other stuff you can do
with it.

Cheers
JulieD
 
X

xlcharlie

what about if I want to set up a default value for the drop-down? Data
validation does not default to a particular selection.
 
J

JulieD

Hi Charlie

once you've set up data validation, type the "default" value in the cell. -
if you're using this workbook as a template it will always be there.

Cheers
JulieD
 
Top