Hi, hope someone can help!
I have combo box in a user form where I get a Type Mismatch error when instead of selecting an option from the drop down menu, you type in the combo box which would then use predictive text.
The problem comes when you accidentally type wrong then it would give a Type Mismatch error. See attachment
Is there any way of preventing this error from happening? Maybe a message telling the user that they typed wrong and to retype again or select the correct option?
Thanx
That code was trying to set the .Value of the combo box before it had anything in its list.
Also, instead of using the End command, one should Unload the user form when the close button is clicked.
You might replace all that UF code with this. Note that the VLOOKUPS have been replaced by using a two column ComboBox. Since the RowSource property is not supported in all versions of Excel, that was changed as well.
Please Login or Register to view this content.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
For ComboBox set value 2-fmStyleDropDownList in Properties window. Name of Property - Style
I'm sorry my english...
Hi mikerickson
Awesome thank you!
Hi The Prist
Thanx your way also worked however in my main workbook, I have a lot of options in the combo box and it would be easier if the user could type in the option activating the predictive text in order to find the option they were looking for a bit quicker than to scroll down to what they were looking for.
But thanx anyway for the reply
Properties -MatchEntry -0-fmMatchEntryFirstLetter
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks