hi,

if need a little program to get a date correct.

i have a column ("a:a") were i can put in dates of vacations

but now i need to program a textbox that, if you put in a date in tha
textbox,
it will look into the column and sees if the date is in the column ye
or no.
if it is in the column it has to do the date + 1 and loop until th
date isn't in the column anymore.

the only problem is that i don't know how you can let it look into th
column to find the date.

so

i have 2 textboxes

textbox1 = date
textbox 2 = date +21 days
and if that date is somewhere in the column he does that date + 1.

can someone tell me the code how you can search on a date in a column?

th

--
tomro
-----------------------------------------------------------------------
tomro1's Profile: http://www.excelforum.com/member.php...fo&userid=3508
View this thread: http://www.excelforum.com/showthread.php?threadid=55050