LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 20
Default VBA Search Date Range and Populate Spreadsheet Cells

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
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
Populate worksheet with data that meets date range criteria P0llyW0G Excel Worksheet Functions 3 September 28th 08 10:01 PM
Search multiple cells with conditions, sum and auto populate! Desperately seeking hammer !! Excel Worksheet Functions 3 August 18th 07 12:20 AM
if date=then populate cells inkrisitive Excel Programming 0 June 26th 06 09:22 PM
Populate a range of cells from a function 4eyed Excel Programming 2 June 1st 05 11:17 PM
Range of Cells to populate in a text box on a userform BenjiHarshbarge Excel Programming 1 November 4th 03 10:09 PM


All times are GMT +1. The time now is 07:20 AM.

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

About Us

"It's about Microsoft Excel"