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!

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

Excel macro Query questions

Status
Not open for further replies.

hd65

Technical User
Aug 17, 2000
27
US
First..I'm new to VB and macros.
And I'm just looking for some help to get started in the right direction.
Here's what I'm trying to do.
I have some CSV files that I want to query based on a user input in a textbox and I want the query results to be displayed in a combobox. I need this to happen via a macro.
I've looked through the excel vb help and there's lots of info too much for my newbee mind.
So if someone has some helpful advice it would be great.

paul
 
What you suggest is certainly doable. It would require coding to build the queries, screen handling, etc.

Might I suggest concentrating on getting the CSV data into a worksheet, then using XL built in filter, sorting, and mathematical capabilities to accomplish your needs?

If you would send a typical CSV file to JVFriederick@Yahoo.com I would be happy to incorporate it into some templates I have around. Then you can view the results and further modify to suit your needs.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top