| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Prevent edit on combo box?
I initially added 3 integer values to my combo box,
then I set the value of the combo box to the first integer. I want my combo box to ONLY offer these 3 integer choices, but I see that it's possible for a user to edit the value of the combo box. How can I prevent users from changing the front value of a combo box? Thank you! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Prevent edit on combo box?
Set the MatchFound property of the ComobBox to TRUE.
Check out the VBE Help on 'MatchFound'. -- Hope this helps. If it does, please click the Yes button. Thanks in advance for your feedback. Gary Brown "Robert Crandal" wrote: I initially added 3 integer values to my combo box, then I set the value of the combo box to the first integer. I want my combo box to ONLY offer these 3 integer choices, but I see that it's possible for a user to edit the value of the combo box. How can I prevent users from changing the front value of a combo box? Thank you! . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combo Edit box | Excel Programming | |||
| Prevent edit of cells | Excel Worksheet Functions | |||
| How to prevent focus by clicking combo box ? | Excel Programming | |||
| Allow Edit Prevent Delete | Excel Worksheet Functions | |||
| How do I prevent users to delete a worksheet, but allow to edit? | Excel Discussion (Misc queries) | |||
Hybrid Mode
