Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel list box or combo box - filled with data from SQL query
Hi, I hope I am right here.. if not apologies.
Following problem: I like to create a listbox or a combobox (result can be 500 rows) which contains values from an SQL query. depending if from the other comboboxes a certain value was selected the list values gets updated. However, my problem is, I do not get the listvalues added at all through the SQL query. I know how it works in Access but have never done this in Excel. Also the selected value on the end shall be used as part of the Where Statement for another SQL query out of Excel. Does anyone know if this is possible at all, and if it is possible, do you have an example where and how I can get started? Thanks hannes |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combo filled and unfilled radar charts | Charts and Charting in Excel | |||
Changing items in cells that are filled using Data Validation List | New Users to Excel | |||
How can I make Excel add an empty row every filled one in a list . | Excel Worksheet Functions | |||
Macro to check data from excel list against access query and return value back to excel | Excel Worksheet Functions | |||
Macro to check data from excel list against access query and return value back to excel | Excel Programming |