How to add Restrictions to Combo Box?/

  • Thread starter Thread starter Balazee
  • Start date Start date
B

Balazee

Hello,

I'm relatively new to VBA.

My problem is I have created a combo box and I want the user to be
restricted to the drop down selection only.

Example. If the user has options of choosing from A, B, C and D...I
want to restrict the user to these options only. Currently the user can
enter any Value and that gets recorded...

I'm using VBA userforms for Combo Box...

Any help is appreciated...

Thanks...

Balaji..
 
Rightclick on the combobox (while in design mode).

Select properties
scroll to Style
and change that to fmStyleDropDownList
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Add Restrictions to ComboBox...??? 5
combo boxes 2
Linking to combo box selection 2
Combo boxes like an option group? 5
Counting Combo Drop Down Box Selections 1
combo box 1
Cascading combos in datasheet 0
Using Formulas for Data Validation 1

Back
Top