View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary Brown[_6_] Gary Brown[_6_] is offline
external usenet poster
 
Posts: 126
Default 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!


.