Quote 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.