Results 1 to 6 of 6

VBA code for changing color of dots upon click not working as it once did

Threaded View

jenny1234 VBA code for changing color... 12-19-2013, 11:58 AM
abousetta Re: HELP!!! I made a code and... 12-19-2013, 12:09 PM
abousetta Re: VBA code for changing... 12-19-2013, 12:19 PM
jenny1234 Re: VBA code for changing... 12-19-2013, 12:51 PM
abousetta Re: VBA code for changing... 12-19-2013, 01:31 PM
abousetta Re: VBA code for changing... 12-19-2013, 03:38 PM
  1. #1
    Registered User
    Join Date
    12-04-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    2

    Unhappy VBA code for changing color of dots upon click not working as it once did

    This is my code:

    Private Sub oval6_Click()
    If ActiveSheet.Shapes("Oval 6").Fill.ForeColor.RGB = RGB(119, 119, 119) Then
    ActiveSheet.Shapes("Oval 6").Fill.ForeColor.RGB = RGB(32, 177, 222)
    Else
    ActiveSheet.Shapes("Oval 6").Fill.ForeColor.RGB = RGB(119, 119, 119)
    End If
    End Sub
    Private Sub oval5_Click()
    If ActiveSheet.Shapes("Oval 5").Fill.ForeColor.RGB = RGB(119, 119, 119) Then
    ActiveSheet.Shapes("Oval 5").Fill.ForeColor.RGB = RGB(32, 177, 222)
    Else
    ActiveSheet.Shapes("Oval 5").Fill.ForeColor.RGB = RGB(119, 119, 119)
    End If
    End Sub
    Private Sub oval1_Click()
    If ActiveSheet.Shapes("Oval 1").Fill.ForeColor.RGB = RGB(119, 119, 119) Then
    ActiveSheet.Shapes("Oval 1").Fill.ForeColor.RGB = RGB(32, 177, 222)
    Else
    ActiveSheet.Shapes("Oval 1").Fill.ForeColor.RGB = RGB(119, 119, 119)
    End If
    End Sub
    The point is for all of these dots to change color when clicked and back to grey when clicked again...
    It worked once, but then it shut down without warning and I had to start over...I copy and pasted the code back into the VBA and now its not working. I have 156 of this code. for all the bubbles.

    Help?!
    selecteddot.PNG
    dots.PNG
    Last edited by jenny1234; 12-19-2013 at 12:17 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Code worked (copying code to the end of a column) then only entered the top line.
    By markDuffy in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-26-2013, 03:33 AM
  2. URGENT: Macro That Worked Fine Not Working Now - No Changes Made To Code
    By stevevb in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 05-19-2013, 05:49 PM
  3. Code that has worked before now not working?!
    By CacheUK in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-07-2008, 07:22 AM
  4. code worked but not now??
    By Mungyun in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-29-2008, 06:05 PM
  5. [SOLVED] Made a button, added code, now what?
    By travis in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-03-2006, 06:50 AM

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