+ Reply to Thread
Results 1 to 12 of 12

Hover over button and change it's colour

Hybrid View

  1. #1
    Registered User
    Join Date
    03-15-2008
    Posts
    10

    Hover over button and change it's colour

    hey i need a button to run a macro but i don't like the standard plain grey buttons that excel offers. i saw a friend using one in his project but don't want to ask him how he did it as it would be considered copying. i will add an image to explain my specifications. there must be an easier way than having to design it and you vba to code the colour change.

    \1

    thanks in advance and im sorry if this is a n00bish question.

  2. #2
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    See if links and attachment helps

    http://www.bettersolutions.com/excel...A928011611.htm
    http://www.bettersolutions.com/excel...B926422321.htm
    http://www.bettersolutions.com/excel...T423111411.htm

    VBA Noob
    Attached Files Attached Files
    _________________________________________


    Credo Elvem ipsum etian vivere
    _________________________________________
    A message for cross posters

    Please remember to wrap code.

    Forum Rules

    Please add to your signature if you found this link helpful. Excel links !!!

  3. #3
    Registered User
    Join Date
    03-15-2008
    Posts
    10
    thanks for the quick response. going to try it out now!

  4. #4
    Registered User
    Join Date
    03-15-2008
    Posts
    10
    im having trouble as im running excel 2007 and all the menus are different. could anyone please help me who is using excel 2007 please?

    edit: i think im on to it now. i made a shape wit text on. just need to know how to implement the colour change upon click.
    Last edited by gpcool; 03-15-2008 at 08:17 AM.

  5. #5
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988

  6. #6
    Registered User
    Join Date
    03-15-2008
    Posts
    10
    yeh all the links helped me a lot.

    Now i have a shape that looks like the image in the picture in my opening post. when i click on it a macro runs properly. So the button works, however i would like to get it to change colour (see image in OP) before it runs the macro. How will i do this?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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