![]() |
Mesage based on table
I have the following table that reminds us of when changes need to be made:
Agency Added Tie 7-9 Tie 10 - 12 Convert ATT Apr-05 Sep-05 Dec-05 Mar-05 ANC Oct-05 Mar-05 Jun-05 Sep-06 I'd like to set up a MsgBox that says something to the effect of If G17 = Sep-05 then "Tie 7-9" for "ATT". If G17 = Jun-05 then "Tie 10-12" for "ANC" How can I tell VBA to compare the date in G17 and give me the Column and Row headings so I know which changes are due this month? |
All times are GMT +1. The time now is 01:55 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com