ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   drop-down populated from external data (https://www.excelbanter.com/excel-programming/394906-drop-down-populated-external-data.html)

hll

drop-down populated from external data
 
Is there a way to get a list box to have the values in it populated from an
external data source?

merjet

drop-down populated from external data
 
You are more likely to get an answer if you say specifically what kind
of external data source.


Hth,
Merjet


hll

drop-down populated from external data
 
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.


"merjet" wrote:

You are more likely to get an answer if you say specifically what kind
of external data source.


Hth,
Merjet



Sajit

drop-down populated from external data
 
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.

--
Sajit
Abu Dhabi


"hll" wrote:

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.


"merjet" wrote:

You are more likely to get an answer if you say specifically what kind
of external data source.


Hth,
Merjet




All times are GMT +1. The time now is 10:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com