Add Value & Cell Color With Button

[bdb1974]

Hi guys, the following code clears contents in the Range given.

Please Login or Register  to view this content.

I need a code the will add the value, "activated" when the button is clicked
to the given range.

Next, Is a Toggle button a bottom that executes two commands?
1st command with first click
2nd command with 2nd click?

if so, i really would like to make this a Toggle Button that will execute the
the given range above and the on the 2nd click execute the range
(H1,I1,J1,K1).

A bonus would be to have the cells color turn red that are within the given range when executed.

Any help is appreciated.

Thanks,
bdb

[bdb1974]

Hi guys,

This is the closest I've come to what I'm looking for in addition to what I
posted intially.

The attachment shows button which will change the numerical value within a cell with each click. Basically, I want the action, but, I want the value to
be a text value: "activated". I want this value to appear in C1,D1,F1,G1
on the 1st click, on the 2nd click it should be removed w/no color, and appear in H1,I1,J1,K1 along with red in the cell color.

[JBeaucaire]

First, you don't need to write a value into a cell to toggle through the colors. You can just test for the color that is there already and scroll to the next color in the sequence, like this:

Please Login or Register  to view this content.

Now, your current exercise...you start with 4 scrolling colors above, and now want to go to just one color? Can you demonstrate your desired results with more sample sheets in that workbook?

[bdb1974]

JBeaucaire,

What I had before is closer to the desired result.
I know, the value number of the color does not have to be written in order to display a color.

To start off, I only need to use two colors (red&green)
What I need is the text value/word: "activated" to appear
in the cell when the color is green. I want it to state, "off" when the cell color is red. In conjuction of that happening, I want another cell to be controlled by the same button, but to display the opposite value each time the button is
clicked. This will give me a toggle effect of changing the status of two cells
simultaneously.

Also, I prefer it not change an active cell. Instead, is should change 2 designated cells in row 1
The 2 does not matter, I can customize this later.

Thanks,

bdb

[JBeaucaire]

Like this?:

Please Login or Register  to view this content.

That's the code from a Control Toolbox Command Button.

[bdb1974]

Perfect!

I can work with this.

This does exactly what I need, I've adjusted the colors and the range
to meet my needs. Thanks

bdb