+ Reply to Thread
Results 1 to 4 of 4

change the color of a oval or square on a application Events = True statement

  1. #1
    Registered User
    Join Date
    02-10-2018
    Location
    toronto ontario
    MS-Off Ver
    office 2010
    Posts
    66

    change the color of a oval or square on a application Events = True statement

    I have a user form that can be turn on or off on a work sheet using a on button or the off button
    What I would like to do would be change the back ground color of a oval from gray to green if true and green to gray if false sort like a pilot light
    there 2 buttons I use run the following macro

    Please Login or Register  to view this content.

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,986

    Re: change the color of a oval or square on a application Events = True statement

    .
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    02-10-2018
    Location
    toronto ontario
    MS-Off Ver
    office 2010
    Posts
    66

    Re: change the color of a oval or square on a application Events = True statement

    Hi
    that's kinda what I am looking for
    but when I run the code I get Run time Error Item with specified name wasn't found

    Is it because the Oval 1 is not defined if so where would I define it and how it is on Sheet 1

  4. #4
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,986

    Re: change the color of a oval or square on a application Events = True statement

    .
    In the example file I worked with, the first oval shape that I placed on the worksheet was auto-named "Oval 1".

    You will need to edit that name in the code to the name of your oval shape.

+ 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. Condensing my Code - Changing Multiple Oval Color
    By Miricleman in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-08-2016, 10:48 PM
  2. Click oval check buttons to fill and unfill color
    By Rocky2013 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-19-2015, 09:00 PM
  3. [SOLVED] Click oval option button to fill/unfill color, also change border color to match fill
    By Rocky2013 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-07-2015, 08:29 PM
  4. Replies: 2
    Last Post: 11-16-2012, 12:03 AM
  5. [SOLVED] if it is true then change the row color
    By pedjvak in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-14-2012, 04:26 AM
  6. Want to change the color of a true/false logical statement with i.
    By gregspainting in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-19-2005, 03:06 PM
  7. How can I make a True or False statement a certain color when usi.
    By Wendy in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-28-2005, 02:06 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