VBA for mouseover a cell

[megnin]

Is there a function to do something on a mouseover a cell. The Comment uses a mouseover.

Alternately, can you make a comment pop up where you want it to? For instance, aligned directly under the cell containing the comment so it looks like a drop down list.

When I create a comment with the list it pops up off to the side on a mouseover and only pops up where I put it when I right click the cell and select "view comment".
...Frustrating...

 

[Jay Petrulis]

On 2002-04-09 11:33, megnin wrote:
Is there a function to do something on a mouseover a cell. The Comment uses a mouseover.

Alternately, can you make a comment pop up where you want it to? For instance, aligned directly under the cell containing the comment so it looks like a drop down list.

When I create a comment with the list it pops up off to the side on a mouseover and only pops up where I put it when I right click the cell and select "view comment".
...Frustrating...

Hi,

No true mouseover event, but you can mimic it somewhat.

In the cell(s) you want, use the Control Toolbox to create an image, which you will size to the dimensions of the cell, with no borders and no shading.

Then, use an event macro with the image (MouseMove, for instance).

It won't be ideal, but may suffice.

Bye,
Jay