MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Excel VBA

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

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?



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.