Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

ComboBox Editing

0

Hello Everyone

I have a form with several ComboBoxes and want to prevent user from entering data manually i.e. force them to use the drop down. I'm uisng excel 2013 or earlier version sometimes.

Is there a singleĀ  vba code such that all the ComboBoxes are prevented to be edited.

Thanks

Answer
Discuss

Answers

0

Every ComboBox has a "MatchRequired" property. If you set that property to TRUE the user will not be able to enter anything but one of the selections available in the dropdown. You can assist that process by also setting the "MatchEntry" property which governs the way the user's input affects display of list entries.

Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login