findings text in columns

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

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

--
Don Guillett
SalesAid Software
[email protected]
"tomro1" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>