Best way to program tooltips in VBA

Hi,
I wrote a VBA macro that reads machine downtimes from a database and visualises this information in a calendar.
Each cell in the excel calendar represents a 2 hour shift. When a cel is clicked a tooltip appears with detailed information.
This works fine but performance is bad. Before adding the 'selection.Validation' command the performance was good.
So the problem is this statement.
Are there better ways to do this ?

Code : coloring each cell and defining the tooltip :

Please Login or Register  to view this content.

Deleted. Double post.

@ MarkSt

Welcome to the forum, please use Code Tags when posting code. (Forum Rule#3)

Why not add the information as a comment ? (Opmerking)

That way you only need to hoover over a cell to get the information.

I tried the following ==>

Please Login or Register  to view this content.

But without success. My problem is that I want to use row and columnnumber and not for example 'A5'.

Try this.

Please Login or Register  to view this content.

From Debra Dalgleish.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

You wanted the red triangles gone so ....

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

Depending where the detailed information was coming from ("scomment" in the original post suggests that it's retreived from somewhere) you could use a textbox.
Being a textbox you can have scrollbars so wouldn't need to worry about sizing or comments becoming distanced from their cells.

Please Login or Register  to view this content.