+ Reply to Thread
Results 1 to 5 of 5

Display text when hovering over cell

  1. #1
    Registered User
    Join Date
    04-19-2014
    Location
    Adelaide
    MS-Off Ver
    Excel 2007
    Posts
    3

    Display text when hovering over cell

    Hi There,

    I have acquired the attached booking form which I have altered a little to suit what I need

    What I can't do and need to do is get the name of the person who has booked the room at that time to show up when I hover my mouse over the cell which is highlighted.

    I also do not need the date range at the top of the booking sheet - i only need a monday to saturday day range instead (i still want the whole week to show up at once.).

    Is anyone able to help??

    Cheers

    Room Roster (Burnside).xls

  2. #2
    Valued Forum Contributor natefarm's Avatar
    Join Date
    04-22-2010
    Location
    Wichita, Kansas
    MS-Off Ver
    2016
    Posts
    1,020

    Re: Display text when hovering over cell

    Which cells are you referring to that you want to hover over?
    How and when is the person that booked the room determined?
    Acts 4:12
    Salvation is found in no one else, for there is no other name under heaven given to mankind by which we must be saved.

  3. #3
    Registered User
    Join Date
    04-19-2014
    Location
    Adelaide
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Display text when hovering over cell

    Thanks for your reply.

    The red room bookings on the right side I was hoping to get the text when you hover over so I know who has booked the room.

    The information in the booking calendar comes from the data inputed on the left side of the screen. It has the name of the person that has booked the room. the times that it needs to be booked and the day of the week there. These are from drop down menus which has data on the far right of the screen.

  4. #4
    Valued Forum Contributor natefarm's Avatar
    Join Date
    04-22-2010
    Location
    Wichita, Kansas
    MS-Off Ver
    2016
    Posts
    1,020

    Re: Display text when hovering over cell

    I think the following code will get you what you need. Just rerun it whenever you want to refresh the cell comments.
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    04-19-2014
    Location
    Adelaide
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Display text when hovering over cell

    Thanks! thats exactly what I was looking for

    Greatly appreciated

+ 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. How to have text hovering over a cell
    By allstarcast in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 11-25-2016, 10:42 AM
  2. My Cell Comments Don't Appear when Hovering.
    By Bouje in forum Excel General
    Replies: 1
    Last Post: 01-07-2013, 04:00 PM
  3. View a picture by the mouse hovering over a cell...
    By DaxtonAllen in forum Excel General
    Replies: 1
    Last Post: 05-22-2012, 04:47 PM
  4. [SOLVED] Issue - Error in text when mouse is hovering over green dot
    By Søren Larsen in forum Suggestions for Improvement
    Replies: 6
    Last Post: 04-10-2012, 06:40 AM
  5. Replies: 1
    Last Post: 01-03-2012, 08:38 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