+ Reply to Thread
Results 1 to 3 of 3

Message/Note appear when hover over shape.

  1. #1
    Forum Contributor
    Join Date
    10-03-2016
    Location
    Sydney, Australia
    MS-Off Ver
    MS 365
    Posts
    128

    Message/Note appear when hover over shape.

    Hi,

    I'd like to insert multiple shapes that will show a message when you hover over it.

    I don't want to click on the shape or hyperlink it to take me to a cell, I'd just like a small box to appear above it to show the text in another cell.

    E.G. Cell Z5 says "Level 2", the shape would by located in cell A5, so when you hover over A5, a small box appears next to the shape and shows "Level 2" in it.

    Is this possible?

    Thanks

  2. #2
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: Message/Note appear when hover over shape.

    Is this what you want?
    Test in attached workbook
    - enter something in column Z
    - find comment in cell in column A

    Any value added in column Z is auto-inserted as comment in column A with this VBA (place in SHEET module):
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by kev_; 10-23-2017 at 04:10 AM.
    Click *Add Reputation to thank those who helped you. Ask if anything is not clear

  3. #3
    Forum Contributor
    Join Date
    10-03-2016
    Location
    Sydney, Australia
    MS-Off Ver
    MS 365
    Posts
    128

    Re: Message/Note appear when hover over shape.

    Precisely what I want, thankyou!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. VBA Code to create hover-over message:
    By Chad Bateman in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-20-2021, 03:32 PM
  2. create a button to hide note box/show note box
    By stephme55 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-27-2016, 07:31 PM
  3. Hover note details
    By afrazier25 in forum Excel General
    Replies: 1
    Last Post: 07-31-2015, 04:06 PM
  4. Mouse Hover over a shape or picture and will display a text message
    By BI Guy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-18-2014, 10:17 AM
  5. Code to change shape colour with mouse hover
    By lorettag1966 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-04-2014, 10:16 PM
  6. [SOLVED] Add Note/Message Box Pop Up when exiting excel
    By mwinter in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-28-2014, 08:26 AM
  7. Click on shape to return message box of shape name
    By beat in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-11-2013, 01:06 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1