Date Range Selections

**Jennybob** · 02-07-2007, 10:31 AM

Hi All!

I've been stuck doing this project and I really need your help!

I have a simple interface designed like so:

Date From: (txtStartDate)

Date To: (txtEndDate)

OK

Cancel

(text box)

I need the program to search through column A and find the date range, and publish the corresponding details from rows A - BV in the text box.

The date in row A is formatted as follows : Wednesday, 07/02/2007

Any help would be greatly appreciated!! Thanks!

**MDubbelboer** · 02-07-2007, 12:35 PM

i think a listview would be most suitable

see attached for an example

**pauluk** · 02-07-2007, 12:41 PM

does i have to appear in the text box?

As it looks like a lot of data.

Would it be simplier to have a form where you select\inout your date range and it outputs these to another sheet in the workbook. You would them be able to manipulate the data.

**MDubbelboer** · 02-07-2007, 12:57 PM

Originally Posted by pauluk

does i have to appear in the text box?

As it looks like a lot of data.

Would it be simplier to have a form where you select\inout your date range and it outputs these to another sheet in the workbook. You would them be able to manipulate the data.

could be, the original poster didn't mention anything about how they wanted to use the data. and i actually just kinda wanted to try to use a listview as i'd never used one before
if they wanted the data copied to a new sheet something like this would be suitable
http://excelforum.com/showthread.php?t=588695
obviously instead of searching for a criteria of B they'd use the date criteria.