craigos
03-24-2013, 02:15 AM
Hi All,
I need help on getting a message popup when specific text is selected from a Validation list in a Column Range.
The Task.
Cells D3 to D300 have Validated list.
On selecting any cell in the range and chosing from the list "Yes - Over 27 Days" a message pops up informing the user what action to take i.e. "You must recalculate the Start Date" with vbOKOnly and on selecting OK the previous cell in Colum C (where the start date is) is selected.
I have tried many variations on the theme using forums but can't find my precise answer.
Many Thanks
Craig
I need help on getting a message popup when specific text is selected from a Validation list in a Column Range.
The Task.
Cells D3 to D300 have Validated list.
On selecting any cell in the range and chosing from the list "Yes - Over 27 Days" a message pops up informing the user what action to take i.e. "You must recalculate the Start Date" with vbOKOnly and on selecting OK the previous cell in Colum C (where the start date is) is selected.
I have tried many variations on the theme using forums but can't find my precise answer.
Many Thanks
Craig