Hi all, i have a Userform3 that has 2 comboboxes on it one selects a
name the other selects a date, when clicking the command button how do
i get to search through arr = Array("Week1", "Week2", "Week3", "Week4",
"Week5", _
"Week6") to find the date and when it does offset(1,x) and change
colour lets say to Red where x would be dependent on the name in the
combobox e.g offset(1,1) would be Lauren offset(1,2) would be Emma and
offset(1,3) would be Cheryl, then once they have had their holiday and
the colour change is older than one week turn the cell colour back to
its original colour (they are different for each girl), The dates
appear only in column A in the places listed below:

Range("A1")
Range("A49")
Range("A97")
Range("A145")
Range("A193")

Probably trying to do too much here!, all help much appreciated!

Regards,
Simon


--
Simon Lloyd
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.excelforum.com/member.php...fo&userid=6708
View this thread: http://www.excelforum.com/showthread...hreadid=557701