D
Diana
Hello, I'm new to this forum, but am desperately seeking some Excel
VBA help...
What I have is a spreadsheet that autopopulates several fields from a
SQL Query Macro into specific cells on the sheet. The fields contain
Date, Item#, Item Name, etc.
What I have done was create a UserForm that requests that the user
input a Start Date and an End Date in its' textboxes...and would
ultimately like this UserForm to search the Date field of the
spreadsheet for the date range provided by the user and pull those
records in the spreadsheet by re-populating the starting cell (where
the SQL Query begins upon opening the spreadsheet).
The problem is...I really have no idea where to begin with the
UserForm code, or if this is even possible. Can I use a UserForm to
pull and populate the sheet, or do I need to add onto the SQL Query
Macro to request that the user input the desired date ranges after the
Query runs upon opening the sheet?
Hopefully this all makes sense, I have been grinding through a lot of
articles but cannot find something specific to my needs.
If you need more information, I can provide as much as I have.
Thank you in advance for all of your help!
~Diana Peterson~
VBA help...
What I have is a spreadsheet that autopopulates several fields from a
SQL Query Macro into specific cells on the sheet. The fields contain
Date, Item#, Item Name, etc.
What I have done was create a UserForm that requests that the user
input a Start Date and an End Date in its' textboxes...and would
ultimately like this UserForm to search the Date field of the
spreadsheet for the date range provided by the user and pull those
records in the spreadsheet by re-populating the starting cell (where
the SQL Query begins upon opening the spreadsheet).
The problem is...I really have no idea where to begin with the
UserForm code, or if this is even possible. Can I use a UserForm to
pull and populate the sheet, or do I need to add onto the SQL Query
Macro to request that the user input the desired date ranges after the
Query runs upon opening the sheet?
Hopefully this all makes sense, I have been grinding through a lot of
articles but cannot find something specific to my needs.
If you need more information, I can provide as much as I have.
Thank you in advance for all of your help!
~Diana Peterson~