allow new value in word vba combobox

I have a combobox in my word vba application that gets it's list from an excel spreadsheet. I get these results using application.workbookfunction.match.

I want the combobox to allow new values to be typed in  if there is no match. How do I allow that?
karimjohnsonAsked:
Who is Participating?
 
Cory VandenbergSenior Risk ManagerCommented:
You cannot type new values into a combobox.  My suggestion is to use a combination of a text box and combobox.  Use a conditional to Enable the text box.  Basically, check to see if the Match result was #N/A, and if it was, enable the TextBox for user input.
0
 
karimjohnsonAuthor Commented:
can you give me a code snippet for the test? Currently I set a variable to the rownumber that is found in the match statement. If no match is found I get an error.
0
 
Cory VandenbergSenior Risk ManagerCommented:
Post the code you currently have and I will see what I can do.
0
 
gbanikCommented:
Yes... do post in more details about the problem.
You may want to solve this problem by conditionally showing a combobox and a text box.
0
 
NorieVBA ExpertCommented:
How are you populating a combobox using the worksheet function MATCH?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.