Improve company productivity with a Business Account.Sign Up

x
?
Solved

allow new value in word vba combobox

Posted on 2010-09-06
5
Medium Priority
?
686 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 2000 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 37

Expert Comment

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

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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.

Join & Write a Comment

This article presents several of my favorite code snippets.
With the functions here, you can parse, convert, and format back and forth between feet and inches and fractions and decimal inches - for normal as well as extreme values and with extreme precision.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

602 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