Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

There are some comments in my Excel sheet

Is it possible to make them appear faster when user hovers a mouse pointer over cell? Currently there is a small delay before the comment pop ups, I'd like the comment to appear instantly (as soon as the mouse enters the cell).

I couldn't find such option in GUI, so maybe there is some hacking approach via VBA?

share|improve this question

migrated from Apr 1 '14 at 9:09

This question came from our site for professional and enthusiast programmers.

all I am saying - it takes some time to see the tooltip.. I thought that maybe it is possible to change some config via VBA, in order to show comments instantly. – Alex Apr 1 '14 at 9:19
oh, I didn't mean the animation of any sort.. sorry if it confused you. In fact - I disabled all animations in office. What's left now - is that once you hover your mouse oven a cell with the red small triangle - the comment tooltip will appear after some time. I have 10 of such cells in a row. It would be a lot easier, if comment appeared instantly, asap user hovers cell with a mouse cursor.. – Alex Apr 1 '14 at 9:23
What about if you just show comments all the time? you can position them so they don't interfere with the view of cells.. – Raystafarian Apr 1 '14 at 16:19
Or if you really want to get into it – Raystafarian Apr 1 '14 at 16:30
It's better to just leave the commented cell and go back, then it will display. – Raystafarian Apr 1 '14 at 16:31
up vote 1 down vote accepted

This isn't possible with VBa, and you've already seen there is no option to configure it in Excel.

In regards to VBa, there is no mouseover event or similar for cells. The only way you could do something is to hack it, by adding a control to every cell you want this and create a mouseover event for each control!


share|improve this answer
Without selecting the cell, there is no VBA event. This is the correct answer. – Raystafarian Apr 1 '14 at 16:27

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .