toggle button text colour

G

Guest

is it possible to have toggle button text colour grayed out if cell value is
false and text colour black if cell value is true?
 
G

Guest

Assuming you refer to a toggle button from the Controls toolbox, and also
assuming what you want to do is disable the button: yes.
Worksheets("SheetName").ToggleButton1.Enabled = Range("CellAddress").Value
 
D

Dave Peterson

You have another response to your post in .misc

John said:
is it possible to have toggle button text colour grayed out if cell value is
false and text colour black if cell value is true?
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Assigning Functions to Toggle Buttons 2
toggle button text 3
Excel 2007 VBA shape fill colour problem 4
Colour a row, based on a cell value 8
Copy format macro needed 3
Colour format code 2
BLINK CELL COLOUR OR TEXT BY CONDITIONAL FORMATTING 1
Microsoft Excel VBA: Concatenate without formatting 1

Top