Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Combo filled and unfilled radar charts Zergrinch Charts and Charting in Excel 3 July 7th 09 03:37 PM
Changing items in cells that are filled using Data Validation List akkrug New Users to Excel 2 July 1st 08 01:03 PM
How can I make Excel add an empty row every filled one in a list . Diego C. Excel Worksheet Functions 3 March 6th 08 11:08 PM
Macro to check data from excel list against access query and return value back to excel dreamkeeper Excel Worksheet Functions 0 October 31st 07 07:26 PM
Macro to check data from excel list against access query and return value back to excel dreamkeeper Excel Programming 0 October 31st 07 07:26 PM


All times are GMT +1. The time now is 03:08 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"