Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 139
  • Last Modified:

Excel and VBA with Combo Boxes

I have an Excel spreadsheet. I will bind a datasource to the spreadsheet that displays the results. If one of the fields that is returned is a value in a drop-down, how do I get that value AND the rest of the values that are in the drop-down?


Lisa
0
lmred
Asked:
lmred
1 Solution
 
jphowCommented:
I did look at this query too, but don't know the answer - sorry.

As there has been no response for a week, is it still a problem?

Can you add some more detail:

what does the excel worksheet look like?
how do you populate the cells?
0
 
lmredAuthor Commented:
I do a "get external data" which uses a view. The results that come back are what populates the cells. The values from docstatus comes from lookup tables. It looks something like this:

DocNumber    DocName    DocStatus   Typeid

22           xxx         Open       Invoice
23           yyy         Closed     Contract
24           zzz         Pending    Invoice

I have figures out a way around it. But it still would be nice to know how to do it the right way.

Lisa
0
 
jphowCommented:
From this example which value do you want to get to?

What was your solution?
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
lmredAuthor Commented:
The docstatus column I want to be a combobox. I ended up creating a form that appears when somebody types in the docstatus column which has a dropdown of the different status. Whatever status the user chooses fills in the cell they were in.

Lisa
0
 
jphowCommented:
Your solution sounds fine to me.
0
 
lmredAuthor Commented:
Thanks!
0
 
CleanupPingCommented:
Hi lmred,
This old question (QID 20569167) needs to be finalized -- accept an answer, split points, or get a refund.  Please see http://www.cityofangels.com/Experts/Closing.htm for information and options.
0
 
GrahamSkanRetiredCommented:
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
PAQ/refund
Please leave any comments here within the next seven days.
 
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!
 
GrahamSkan
EE Cleanup Volunteer
0
 
NetminderCommented:
Per recommendation.

Netminder
EE Admin
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now