Freeze Data in drop-down combo box list

[RJQMAN]

Hello. I am using a form (several actually) with drop-down lists. My
program is used by unskilled computer people, and I have tried to make
it user-friendly and error-resistant, but I found an unexpected
problem. I do not know what to do about this one.

Each drop-down list has up to 20 entries, and the user selects one of
these entries. The problem happens because the user can accidentally
change the entries when selecting it.

For example, in one case, the entries are street addresses. The
address on the drop-down list could be 18 Elm Street. The user could
change that (accidentally) to 18 Elm Streete by hitting the 'e' key
when selecting that entry. My program depends on the address being
precisely what is stated in the drop down list, and this accidental
change causes major problems in other sections of the program.

My question is, is there any way to 'freeze' the items in the drop-
down list so that the user cannot accidentally hit an extra key and
change the item when selecting it?

Thanks to all who help on this group. The manuals are so frustrating.

 

[Rob Bovey]

Change the Style property of each ComboBox control to "2 -
fmStyleDropDownList". This will prevent the user from being able to do
anything other than select one of the list entries that you have provided.

--
Rob Bovey, Excel MVP
Application Professionals
http://www.appspro.com/

* Take your Excel development skills to the next level.
* Professional Excel Development
http://www.appspro.com/Books/Books.htm

 

[Tim Zych]

To add to what Rob said, if you want to make it really restrictive also
change the MatchEntry property to 2 - fmMatchEntryNone. That will prohibit
a-z and A-Z keys from matching the combo value to the closest matching
key(s).

 

[RJQMAN]

    Change the Style property of each ComboBox control to "2 -
fmStyleDropDownList". This will prevent the user from being able to do
anything other than select one of the list entries that you have provided.

--
Rob Bovey, Excel MVP
Application Professionalshttp://www.appspro.com/

* Take your Excel development skills to the next level.
* Professional Excel Developmenthttp://www.appspro.com/Books/Books.htm










- Show quoted text -

Thank you very much. The help is greatly appreciated.