Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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~ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Populate worksheet with data that meets date range criteria | Excel Worksheet Functions | |||
Search multiple cells with conditions, sum and auto populate! | Excel Worksheet Functions | |||
if date=then populate cells | Excel Programming | |||
Populate a range of cells from a function | Excel Programming | |||
Range of Cells to populate in a text box on a userform | Excel Programming |