+ Reply to Thread
Results 1 to 2 of 2

Toggle Shape Color

  1. #1
    Valued Forum Contributor
    Join Date
    04-24-2014
    Location
    United States
    MS-Off Ver
    Office 365 ProPlus
    Posts
    853

    Toggle Shape Color

    I'm am working to possibly create a dynamic chart where the user will click various buttons or shapes that will add or take things off the chart. And when the user presses that button or shape it will change the color to show its 'On' or 'Off.

    So say I have perhaps 7 or 10 buttons or shapes, what would be the best possible way to toggle each shape color 'On' and 'Off'

    The idea below is that the script will hide and unhide the column in the data, which will then add or remove that data in the chart and change the shape color. But do I need to have separate 7+ modules, one each for expense, etc?

    Please Login or Register  to view this content.
    Last edited by ptmuldoon; 11-26-2020 at 10:38 PM.

  2. #2
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent Monthly Channel / Insiders Beta
    Posts
    8,903

    Re: Toggle Shape Color

    Is there any way for the code to determine, from the shape being clicked, which column should be hidden?
    Rory

+ 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. Click a shape to toggle black fill and change line color to black
    By Rocky2013 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-23-2020, 01:29 PM
  2. Trying to change shape color when selecting toggle button - Code gives Error
    By JJFletcher in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 05-01-2016, 01:38 PM
  3. [SOLVED] Toggle Colour of Active Shape
    By Dave21 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-23-2013, 06:06 AM
  4. Add command button to shape and change shape color on mouseover
    By maacmaac in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-26-2012, 05:12 PM
  5. Toggle Shape Line Color VBA
    By cmstroh in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-10-2012, 08:26 PM
  6. [SOLVED] make a shape a toggle
    By Spencer Hutton in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-14-2005, 12:06 AM
  7. [SOLVED] Re: make a shape a toggle
    By Norman Jones in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-13-2005, 11: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