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

have a look in vba help index for FINDNEXT. There is an example.

--
Don Guillett
SalesAid Software

"tomro1" wrote in
message ...

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 that
textbox,
it will look into the column and sees if the date is in the column yes
or no.
if it is in the column it has to do the date + 1 and loop until the
date isn't in the column anymore.

the only problem is that i don't know how you can let it look into the
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?

thx


--
tomro1
------------------------------------------------------------------------
tomro1's Profile:
http://www.excelforum.com/member.php...o&userid=35081
View this thread: http://www.excelforum.com/showthread...hreadid=550504