Solved

allow new value in word vba combobox

Posted on 2010-09-06
5
672 Views
Last Modified: 2013-11-26
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?
0
Comment
Question by:karimjohnson
5 Comments
 
LVL 18

Accepted Solution

by:
Cory Vandenberg earned 500 total points
ID: 33611988
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
 

Author Comment

by:karimjohnson
ID: 33612199
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
 
LVL 18

Expert Comment

by:Cory Vandenberg
ID: 33614306
Post the code you currently have and I will see what I can do.
0
 
LVL 13

Expert Comment

by:gbanik
ID: 33617024
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
 
LVL 33

Expert Comment

by:Norie
ID: 33620596
How are you populating a combobox using the worksheet function MATCH?
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Word is a program we have all encountered at some point, but very few of us have dug deep into its full scope of features, let alone customized it to suit our needs. Luckily making the ribbon (aka toolbar, first introduced in Word 2007) wo…
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
In a previous video Micro Tutorial here at Experts Exchange (http://www.experts-exchange.com/videos/1358/How-to-get-a-free-trial-of-Office-365-with-the-Office-2016-desktop-applications.html), I explained how to get a free, one-month trial of Office …
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now