ComboBox Problem

Can_This_Be_Don

Board Regular
Joined
Feb 15, 2005
Messages
88
Have inherited a spreadsheet which meets the required purpose 95% of the time. The problem relates too combo boxes on a userform.

Currently when data is input into the combo box anything can be added which is not already there. I want to be able to stop the user from doing this. Have looked on various posts and have found that i can change the properties to 2-frmStyleDropDownList.

If I do this then it just seems to stop the code running at a later stage. If the original setting is retained then the code runs fine.

Is there away to overcome this?

Sorry if the question is a bit vague but have only just started using Excel and am still learning.

Don
 

Some videos you may like

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

Gettingbetter

Well-known Member
Joined
Oct 12, 2004
Messages
602
If you are trying to say that you only want them to be able to choose from the options in the combobox and not input there own info

click on the combo box (in visual basic) then find the field MatchRequired in the properties and change to true

hope this Helps

Cheers
 

Watch MrExcel Video

Forum statistics

Threads
1,122,514
Messages
5,596,612
Members
414,080
Latest member
penguin23

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top