View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Hannes Hannes is offline
external usenet poster
 
Posts: 30
Default 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