Excel Input Message

[ErinJ]

I am trying to create a Gantt Chart using Excel to track our projects.

Down Column A I have several (12) projects
Then I have 7 columns that represent each day grouped into 12 weeks.

I want to mouseover the column and see what day it represents.

I tried comments but I didn't like the indicator showing and I have to hand key each date into each comment.

I tried data validation which eliminates the indicator but I still have to hand key in the dates.

What I'm thinking is somehow using the input message I can call a date represented from a different sheet. For example have Sheet 2 with a list of dates and the input message reference the corresponding cell.
Can this be done?

 

[villy]

You can do it through VBA code

 

[ErinJ]

Thank you Villy I thought you could. But I'm at a loss as to how.

 

[Jerry Sullivan]

Erin,

My response to your similar post, might address this problem too.
http://www.mrexcel.com/forum/showthread.php?t=567979

One difference between comments and validation messages is that comments can appear on mouse over; whereas the user needs to select the cell to see the validation message.

If you prefer to use comments instead of validation, the Contextures site shows how you can place a triangle over the comment indicator to have it appear to have a different color.
http://www.contextures.com/xlcomments02.html
You could use this code and match the triangle color to your cell fill color if you want to hide the indicators.

 

[ErinJ]

Thanks - worked exactly like I asked it to.