| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Populating a table based on values in another table | Excel Worksheet Functions | |||
| Printing a table based on a larger table | Excel Worksheet Functions | |||
| I want a mesage sent when a change is made to an excel file | Excel Discussion (Misc queries) | |||
| get rid of mesage boxes | Excel Programming | |||
| No more fonts allowed for this file error mesage | Charts and Charting in Excel | |||
Threaded Mode
