Thread
:
findings text in columns
View Single Post
#
2
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
findings text in columns
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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett