+ Reply to Thread
Results 1 to 2 of 2

Changing color of autoshapes when clicked - only 1 colored in at a time

  1. #1
    Registered User
    Join Date
    02-21-2013
    Location
    Ontario, Canada
    MS-Off Ver
    Office 2010
    Posts
    96

    Changing color of autoshapes when clicked - only 1 colored in at a time

    Hi there,

    I have some code that changes the color of an autoshape when clicked. This code also takes the text value inside and displays it in a separate cell. It works perfectly however I also want to only allow 1 shape to be colored in at a time (I want to use this as a type of audit form that has like 5 categories and you rate between 1-5 for each category. The shapes will be the 1-5 numbers and when you click on a shape it adds the value inside to your total score)

    Another issue i see is that when i click on 1 shape, then click on another one, it takes the value of the second shape i clicked (which technically it should) but when i click the second shape again it still keeps that same value and doesnt use the value of the first shape that is still colored in. This is due to the fact that the code is just looking at the shape i am clicking on at the time.

    Here is my code:

    Please Login or Register  to view this content.
    Any help is appreciated.

  2. #2
    Registered User
    Join Date
    02-21-2013
    Location
    Ontario, Canada
    MS-Off Ver
    Office 2010
    Posts
    96

    Re: Changing color of autoshapes when clicked - only 1 colored in at a time

    This code ended up fixing most of my issues:

    Please Login or Register  to view this content.
    The problem i am having now is that i can't uncheck any of the shapes. I can loop through them by clicking them individually but if i click one and the color changes, it doesn't change back when i click it again.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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