+ Reply to Thread
Results 1 to 8 of 8

Glowing button on Hover

  1. #1
    Registered User
    Join Date
    10-19-2016
    Location
    London
    MS-Off Ver
    7
    Posts
    14

    Glowing button on Hover

    I'm trying to create a button that glows when you hover over it.

    I also need the button to have no outline.

    The method I have used seems to be a tad messy and it isn't the desired result I want. I was wondering if anyone could offer any advice on how to make it better. I have used the MouseMove event on two buttons. There is a small button on top of a larger button. The small button activates the glow property when hovered over and the larger button deactivates it for the region outside. At the moment I have a horrible outline which I dont want.

    Please see the attached spreadsheet to see exactly how it works.

    To be clear I want to go from this

    unhover.jpg

    When I'm not hovering over the shape/button

    to this

    hover.jpg

    When I am hovering over the button. And I want to assign a macro to the button that will do something else.

    Any advice would be greatly appreciated.

    Thanks
    Attached Files Attached Files

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,482

    Re: Glowing button on Hover

    You could try the rollover hyperlink. You would need to have a function to alter glow state which surrounds and covers the button. You may still have the issue of the glow remaining if the mouse is moved too quickly

    http://optionexplicitvba.blogspot.co...er-b8-ov1.html
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    10-19-2016
    Location
    London
    MS-Off Ver
    7
    Posts
    14

    Re: Glowing button on Hover

    Thanks Andy. I also tried this approach but the result wasn't particularly good

  4. #4
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Glowing button on Hover

    Hi,

    It should work better if you avoid selecting the shape. You can also replace the larger button with an empty label and then use
    Please Login or Register  to view this content.
    Last edited by xlnitwit; 06-08-2017 at 05:21 AM.
    Don
    Please remember to mark your thread 'Solved' when appropriate.

  5. #5
    Registered User
    Join Date
    10-19-2016
    Location
    London
    MS-Off Ver
    7
    Posts
    14

    Re: Glowing button on Hover

    Thanks xlnitwit. I might just make the larger button so large that it is out of the view-able screen as a hacked solution since I dont know how to get rid of the outline of the button.

    Thanks again.

  6. #6
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Glowing button on Hover

    See my edited post- using a label rather than a second button will remove the outline.
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    10-19-2016
    Location
    London
    MS-Off Ver
    7
    Posts
    14

    Re: Glowing button on Hover

    ah...wonderful. Thanks so much xlnitwit. It also means I can get rid of some code which is always good.

    much appreciated

  8. #8
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Glowing button on Hover

    You're welcome. Please remember to mark the thread Solved using the Thread Tools link at the top.

+ 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. Web browsing, remote click a mouse over (hover over) button
    By toolman_dustin in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-19-2015, 12:51 PM
  2. Change Macro Button Description for Hover Over
    By Chaba in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-22-2014, 03:30 PM
  3. [SOLVED] How to make 'button' change colour when hover over them
    By danlRB80 in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 09-11-2013, 06:17 AM
  4. Button changes in appearance with a mouse hover
    By jeff_kaufman in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-18-2013, 11:50 AM
  5. Show tooltip on hover of button (autoshape)
    By wotadude in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-04-2009, 12:42 PM
  6. Hover over button and change it's colour
    By gpcool in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 03-15-2008, 05:37 PM
  7. [SOLVED] a button that will hover
    By Ben in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-13-2006, 12:15 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