![]() |
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! |
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! . |
All times are GMT +1. The time now is 07:49 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com