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