Dynamic Message Boxes

[mike ryan]

Hello All,

I'm having a bit of an issue that I am hoping one of you could help with.

I'm hoping to script a macro that will check for one of 2 specific text results from a vlookup in a range.

Basically, on sheet 1 I have a vlookup running from columns Y to AD, looking up a series of dates in columns P to U t check if any of them are either weekends or bank holidays. What I want is a msgbox to appear when the drop down in column F = "yes", and any of the returned results in columns Y to AD produce a result of either "Weekend" or "Bank Holiday"?

I've attached a workbook which will hopefully make clearer what I am looking to do.

Many Thanks.PBI tests.xlsx

[xladept]

Hi Mike,

Here's some event code for your Sheet1:

Please Login or Register  to view this content.

[mike ryan]

Hi xladept,

Thank you so much for taking the time to look at this. Unfortunately I forgot to mention that the bank holiday or weekend phrases appearing in the target range, are generated by a formula, not being input by a user. Is there any way to tweak this code so that it reads the formula result?

[xladept]

Maybe:

Please Login or Register  to view this content.