Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Populating an Excel List Box.

Status
Not open for further replies.
Taff07

Taff07

MIS
Jul 18, 2001
160
GB

I'm creating a form in Excel and need to populate a ListBox with the results from an Access Query. Can anyone show me how to set this query as the control source or populate it in a nother way?

Thanks

Ian
 
Sort by date Sort by votes
Loop through the recordset and then use the ADDITEM method of the combobox.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Ken01
  • Question
Extraction of Picture box point / pixel colors. 3
Replies
13
Views
1K
klima
K
Swi
  • Locked
  • Question
Read Excel Sharepoint File
Replies
0
Views
120
Swi
Swi
sal21
  • Locked
  • Question
list all printer
Replies
1
Views
102
Andrzejek
Andrzejek
Niki_S
  • Locked
  • Question
How to read an excel file using VB 6?
Replies
17
Views
319
strongm
strongm
Niki_S
  • Locked
  • Question
How to use a combo box to get data from SQL? 1
Replies
1
Views
93
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top