drop-down populated from external data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to get a list box to have the values in it populated from an
external data source?
 
You are more likely to get an answer if you say specifically what kind
of external data source.


Hth,
Merjet
 
Sorry for not being more specific.

I am quering an Oracle database using the ODBC driver. I am assuming puting
the data back in to a List object is the best way to do this but was hoping
someone had a more elegant way.. if there is one.. to do this.
 
I would like to use the validation drop down combo box Vs the normal combo
box, because the validation drop down list is self aligned to a cell. However
the data source has to be on the same sheet itself, I think. Can the data
source be an SQL statement. Is this possible? I would like to know.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Looking for some help launching files from COde & Ribbon control 0
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Passing data to an event handler 3
populate combobox from worksheet in different workbook 3
Need Help with Refreshing Querytables. 8
Populating a listbox from an excel column 2
Use VLOOKUP to populate text box on form 8
Getting information from access table in excel 1

Back
Top