G Guest Aug 8, 2005 #1 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?
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 Aug 8, 2005 #2 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
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 Aug 8, 2005 #3 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...
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...