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 - 26 May 2008 02:17 GMT
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.

Signature
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
> 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
[quoted text clipped - 17 lines]
>
> Thanks to all who help on this group. The manuals are so frustrating.
RJQMAN@gmail.com - 26 May 2008 06:26 GMT
> Change the Style property of each ComboBox control to "2 -
> fmStyleDropDownList". This will prevent the user from being able to do
[quoted text clipped - 34 lines]
>
> - Show quoted text -
Thank you very much. The help is greatly appreciated.
Tim Zych - 26 May 2008 06:03 GMT
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).

Signature
Tim Zych
www.higherdata.com
Compare data in workbooks and find differences with Workbook Compare
A free, powerful, flexible Excel utility
> 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
[quoted text clipped - 17 lines]
>
> Thanks to all who help on this group. The manuals are so frustrating.