Search using user input

[chbrandt]

I've created a spreadsheet that has the months listed going down the page with entries in each month:

January
Entry 1 - 01/05/2011 01/06/2011 Blah
Entry 2 - 01/08/2011 01/08/2011 Blah

February
Entry 1 - 02/07/2011 02/07/2011 Blah
Entry 2 - 02/22/2011 02/26/2011 Blah

March
Entry 1 - 03/06/2011 03/06/2011 Blah
Entry 2 - 03/11/2011 03/12/2011 Blah
Entry 3 - 03/21/2011 03/22/2011 Blah

What I'm trying to do is create a macro that, when ran, will prompt the user for a date for their entry. If they put in 03/15/2011 as their start date, I want a line to be inserted after Entry 2 in March. One way I thought of to do this would be to code the macro such that if they put in 03 as the month, a find runs on March, puts the new line in, with the other user data for that entry (also from prompts), and then sorts the March entries somehow. Is there an easier way to do this? And I'm not exactly sure how to make a starting date of 03/xx/xx search excel for March. Any help would be greatly appreciated!

Chris

[tlafferty]

Be glad to work on it, but I'm not sure how your entries are actually laid out in the book which will have an effect on the search criteria. Can you post a sample workbook with entries laid out the way they'd actually appear?

[chbrandt]

Please see attached. Thanks!

[tlafferty]

Are you intending to drive this using input from the calendar control? If so, you'll want to make sure that any user who gets a copy of the workbook has the control registered in their type libraries or it won't run. Also, could you describe a bit more how you envision the user making the input from the control?

[chbrandt]

The calendar control is just there for easy calendar access. Everything will be driven from user input in popup boxes from the macro.