Hovering over cells to show a date

[cjboydell]

Hello. Could someone please help.

Firstly, I am using Excel 2007.

The purpose of my sheet is a timetable.

What I have is a sheet from B2 to N32. What I would like to do is to be able to hover over a cell to show a date.

I have columns that represent the months, column B is January, coulmn C is February, column D is March, etc, etc. Right up to December in column M.
Row 2 represents the 1st of the month, row 3 is the 2nd, etc, etc, down to the 31st of a month.

What I would like to do is when I hover over, for example, cell B2, I would like a box to pop up to say something like, ' What would like to do on the 1st of January??', then maybe hover over H7 and then a box appears saying, ' What would like to do on the 6th of July??'

I would like this to happen on all cells on the sheet.

Is this possible via VB?? Thank you for reading.

Chris

[Domski]

You can do this by adding Comments to the cells and avoid VBA.

Dom

[sweep]

To add comments as you describe by VBA,

Please Login or Register  to view this content.

[cjboydell]

Thank you for your reply.

To be honest, I am also using the 'Data Validation' option where I get a little message popping up saying 'What am I doing today??' when I click individual cells. I want it say that, but with the corresponding date for the cell, for example, 'What am I doing today on January 1st??' or something like that when I click other cells.

If I use the 'comments' option, I will get two text boxes. One from the 'Data Validation' that I use, and one from the comment

I would just prefer the one

[cjboydell]

Sorry about that. The reply was for DOMSKI.
I will try your VB code , Sweep.

[cjboydell]

Hi Sweep.

Unfortunately, nothing seems to be happening to the sheet once I add the VB code.
I click on the individual cells but no text boxes or anything like that appear.

[sweep]

It works for me. Can you post your sheet? Does the VBA generate an error when run?

[Domski]

There isn't a VBA event that I'm aware of that will recognise when you move the cursor over a particular cell so I think you would be stuck with either comments or the data validation message.

This would add comments to each cell in B2:M32 picking up the info from Row 1 and Column A respectively:

Please Login or Register  to view this content.

Edit: better late than never, boss wanted to chat.

Hope it helps,

Dom

[cjboydell]

Ok.
Thank you very much to Domski and Sweep.

It's not exactly what I wanted but its close enough. I would have prefered a box which appears like a 'Data Validation' box, but not as a comment (little red markers on every cell)

Anyway, it does what I need it to do.

I'll mark it as solved.