+ Reply to Thread
Results 1 to 4 of 4

Mouseover option from one sheet to different sheet

  1. #1
    Registered User
    Join Date
    02-21-2019
    Location
    Germany
    MS-Off Ver
    2010
    Posts
    5

    Mouseover option from one sheet to different sheet

    Hello Everyone good morning,

    I am quite new to Excel specially for VBA. I have read many forums regarding my problem, unfortunately I didn't found the right one. I hope I will get the solution.

    Problem:

    I have two sheets sheet1 as 'Questions' and sheet2 as 'Explanation'.

    In Question sheet I have a question from D8:T10, So when ever user tries to move the mouse(Mouse Over)on the question in the 'Question sheet' then the answer from the Explanation sheet(C11:E17) has to popup in the question sheet. These cells are fixed and in future changes will be done within these cells. I hope everyone understood this problem!! Can anyone suggest the solution. I will attach a sample file for your reference.

    Note: I already tried insert comment option but it is not user friendly, while I am inserting the text in the inserting comment option which is not efficient. Is there any other option
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    06-08-2012
    Location
    Left the forum!
    MS-Off Ver
    Left the forum!
    Posts
    5,189

    Re: Mouseover option from one sheet to different sheet

    Unfortunately excel does not support mouse-over functionality beyond the comments that you have already tried.

    Anything beyond that would need a more direct action from the user (clicking the cell instead of hovering).

    With that method, I would suggest maybe creating you own comments with shapes from the Insert menu, then make them visible, perhaps for a specified time, when the user clicks the cell.

  3. #3
    Valued Forum Contributor Haluk's Avatar
    Join Date
    02-14-2019
    Location
    Türkiye
    MS-Off Ver
    2010 - 64 Bit on Win7
    Posts
    1,004

    Re: Mouseover option from one sheet to different sheet

    As jason.b75 has said; Excel does not support Mouse_Over event on worksheets.

    I am not sure if this helps you but, by using a small UDF we can simulate this action as seen in the attached workbook.

    Move your mouse over the questions (don't click the cells) and see the answers ...
    Attached Files Attached Files
    Last edited by Haluk; 02-26-2019 at 05:53 AM.

  4. #4
    Valued Forum Contributor Haluk's Avatar
    Join Date
    02-14-2019
    Location
    Türkiye
    MS-Off Ver
    2010 - 64 Bit on Win7
    Posts
    1,004

    Re: Mouseover option from one sheet to different sheet

    There was a small problem with the attached file in post #3 and I have just changed it.

+ 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. Is it possible to add a option before print a sheet
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-24-2017, 05:31 AM
  2. Macro to find sheet name with next button option in case of multiple sheet with same name.
    By DEEPAK AGGARWAL in forum Excel Programming / VBA / Macros
    Replies: 38
    Last Post: 05-01-2016, 12:27 PM
  3. Hidden sheet option
    By EXLent in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 07-10-2013, 12:03 AM
  4. [SOLVED] Data to be copied from one sheet to another sheet by Find option
    By mohandeck in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-18-2013, 12:34 AM
  5. Activate Print option with a userform where selected Sheet check box option available..
    By santosh226001 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-03-2013, 08:19 AM
  6. Replies: 5
    Last Post: 05-12-2010, 01:29 PM
  7. [SOLVED] option view (Sheet Tabs)
    By Tarique in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-06-2006, 05:50 PM

Tags for this Thread

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