ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Mesage based on table (https://www.excelbanter.com/excel-programming/339323-mesage-based-table.html)

StephanieH

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