Page 1 of 3 123 LastLast
Results 1 to 10 of 21

Adding Mouseover or Comment to Shapes in Excel

This is a discussion on Adding Mouseover or Comment to Shapes in Excel within the Excel Questions forums, part of the Question Forums category; How can I add a mouseover/comment to an autoshape/freeform shape in excel? Currently I have a shape that runs a ...

  1. #1
    New Member
    Join Date
    Feb 2008
    Posts
    6

    Default Adding Mouseover or Comment to Shapes in Excel

    How can I add a mouseover/comment to an autoshape/freeform shape in excel? Currently I have a shape that runs a macro when clicked. I'd like a little pop up to tell the use what the shape does.

  2. #2
    Board Regular
    Join Date
    Aug 2005
    Posts
    4,565

    Default Re: Adding Mouseover or Comment to Shapes in Excel

    off the cuff suggstion

    put a msgbox at the beginning of the macro. if you click the shape first the msgbox appears and then if you click ok the rest of the macro runs.
    I am not an expert. So better solutions may be available
    MinE WINDOWS 7 AND excel 2007(compatbililty mode)
    venkat1926(at)gmail(dot)com
    preferably do not send private messages in the newsgroup reply to newsgroup

  3. #3
    New Member
    Join Date
    Feb 2008
    Posts
    6

    Default Re: Adding Mouseover or Comment to Shapes in Excel

    Thanks Venkat1926, but the macro allows the user to click through a series of colours to denote the level of importance of the object in the model. Anything that requires additional clicks won't work.

    Thanks

  4. #4
    Board Regular
    Join Date
    Aug 2005
    Posts
    4,565

    Default Re: Adding Mouseover or Comment to Shapes in Excel

    No. there are no additional clicks to the shape. You click once the msgbox appears. the msgbox needs a response mostly "ok". you click ok and then the regular macro starts . try this trivial macro on an empty workbook on sheet 1.

    Code:
    Sub test()
    MsgBox "this macro enters 123 in A1"
    Range("a1") = 123
    End Sub
    I am not an expert. So better solutions may be available
    MinE WINDOWS 7 AND excel 2007(compatbililty mode)
    venkat1926(at)gmail(dot)com
    preferably do not send private messages in the newsgroup reply to newsgroup

  5. #5
    Board Regular Datsmart's Avatar
    Join Date
    Jun 2003
    Location
    Olympia
    Posts
    7,985

    Default Re: Adding Mouseover or Comment to Shapes in Excel

    Right Click the Shape
    Select Hyperlink
    Click Screen Tip
    Type in your message
    Click OK
    Click Bookmark
    Type A1 in the top box
    Click OK
    Click OK

    Edit: OK, this messes up the assigned macro. Working on it.
    Last edited by Datsmart; Feb 12th, 2008 at 08:50 PM.
    John

  6. #6
    Board Regular
    Join Date
    Dec 2007
    Location
    Near Dayton, OH
    Posts
    152

    Default Re: Adding Mouseover or Comment to Shapes in Excel

    Datsmart,

    I like the idea that you've started.

    Could you do the hyperlink with the screen tip and the select the "Place in the document option."

    When the shape is clicked, send it to an unused portion of the spreadsheet. Then have a change selection macro that runs automatically. It's first test condition is to test to see if it is in the unused cell. If it is, then run the macro that Lerumeur really needed to run.

    I think that might get around the macro issue.

    Ryan
    Dad always said, "To find a better way to do something, give the job to a lazy man."
    My addition, " or someone who knows Excel!"

    Advise: Never play leapfrog with a unicorn.

  7. #7
    New Member
    Join Date
    Feb 2008
    Posts
    6

    Default Re: Adding Mouseover or Comment to Shapes in Excel

    Datsmart - did you have any further luck with this by any chance? I wasn't sure how to apply ryan4osu's ideas.

    Thanks

  8. #8
    New Member
    Join Date
    Jan 2007
    Location
    Overland Park, KS
    Posts
    12

    Default Re: Adding Mouseover or Comment to Shapes in Excel

    I'm curious about this as well. In my case I have a sheet that displays hundreds of small images placed side by side to form a map (they each cover one cell and take up the entire cell so only the border shows). Each image runs a macro that then displays details about those coordinates in a userform. I need a comment to appear when they mouse over the images so they know what coordinates that image is for without having to randomly click images to narrow down the location they are looking for.

    If the images don't have a macro assigned I can comment the cell behind the image and the comment appears when mousing over the image since it takes up the entire cell. As soon as you add a macro though you lose the commenting ability.

  9. #9
    MrExcel MVP erik.van.geit's Avatar
    Join Date
    Feb 2003
    Location
    Belgium 3272 Testelt
    Posts
    17,765

    Default Re: Adding Mouseover or Comment to Shapes in Excel

    Hi,

    Check out this thread
    http://www.mrexcel.com/board2/viewtopic.php?t=299770
    I won't probably have the time to help further, but you should get it to work.

    kind regards,
    Erik

  10. #10
    New Member
    Join Date
    Jan 2007
    Location
    Overland Park, KS
    Posts
    12

    Default Re: Adding Mouseover or Comment to Shapes in Excel

    Thanks for the quick reply Erik. I created a new workbook and tried out some of the solutions mentioned in that thread. I think Jaafar's solution would probably do what I'm looking for but from the description it sounds like it should have been popping up a comment box or something. The only time I was able to see anything though is if I clicked on a shape and got the MsgBox with the shape name in it.

    Should I be getting a comment box or something popping up without having to click or am I misunderstanding what it should be doing? Could the version of Excel have anything to do with it (I'm running 2007)?

Page 1 of 3 123 LastLast

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