Greetings Experts,
Probably a simple problem for you:
I have a spreadsheet with 12 sheets (one for each month) and the complete dates across the top.
I am working on a UserForm that requests the user to pick corporate holidays from a Calendar. These dates are then the values of textbox's (TxtHoliday1, etc).
My next step is to search the date rows of each of the 12 sheets for any dates that are listed as holidays (values in the TxtHolidayX). When a match is found, I would like to change the formatting of SOME of the cells in that column. For example, if TxtHoliday1 = 12/25/2007, VBA will find that cell on Sheets("Dec") and Cell(A25). It should then change the format of B25, E25, H25, etc. to a shaded gray and read "HOL".
Does that make sense? I would post code, but I'm not even sure where to start!
Thanks! You all are amazing!
Probably a simple problem for you:
I have a spreadsheet with 12 sheets (one for each month) and the complete dates across the top.
I am working on a UserForm that requests the user to pick corporate holidays from a Calendar. These dates are then the values of textbox's (TxtHoliday1, etc).
My next step is to search the date rows of each of the 12 sheets for any dates that are listed as holidays (values in the TxtHolidayX). When a match is found, I would like to change the formatting of SOME of the cells in that column. For example, if TxtHoliday1 = 12/25/2007, VBA will find that cell on Sheets("Dec") and Cell(A25). It should then change the format of B25, E25, H25, etc. to a shaded gray and read "HOL".
Does that make sense? I would post code, but I'm not even sure where to start!
Thanks! You all are amazing!
