Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Excel VBA

  Asked By: Colleen    Date: Feb 02    Category: MS Office    Views: 886
  

I am attempting to restrict the user to make a selection from a drop
down list on a form. The user should not be able to type anything else.
How do I do this?

Share: 

 

2 Answers Found

 
Answer #1    Answered By: Maurice Hanson     Answered On: Feb 02

Look at protecting the workbook/sheet.............

 
Answer #2    Answered By: Bellona Lopez     Answered On: Feb 02

If it is a ComboBox instead of a ListBox, you need to set the MatchRequired
property to True.

 
Didn't find what you were looking for? Find more on Excel VBA Or get search suggestion and latest updates.




Tagged: