VBA for mouseover a cell
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: VBA for mouseover a cell

  1. #1
    Board Regular megnin's Avatar
    Join Date
    Feb 2002
    Location
    Fort Lauderdale
    Posts
    340
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    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...

  2. #2
    MrExcel MVP Jay Petrulis's Avatar
    Join Date
    Mar 2002
    Location
    Chicago, IL USA
    Posts
    2,040
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    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

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com