ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Prevent edit on combo box? (https://www.excelbanter.com/excel-programming/440794-prevent-edit-combo-box.html)

Robert Crandal

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!



Gary Brown[_6_]

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