Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
CF using Toggle Button result
I am trying to use CF to hide some cells (actually turning the font
color white). I made a Control Toggle Button and linked it to cell G8. The cells I want to hide are say B2...B6 I select that range and goto Conditional Formating 2 Questions: 1) How do I write the "formula is" CF expression testing if G8 is TRUE or FALSE? I tried G8=TRUE but that is not working. 2)How do I change the caption of the Toggle Button to show different text if depressed or not. So I want it to say SHOW and HIDE |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
CF using Toggle Button result
=G8=TRUE should work fine as a CF formula.
You'd need a macro to change the button's caption. Double click the button while you're in design mode and write code like this: Private Sub ToggleButton1_Click() If Range("G8").Value = True Then ToggleButton1.Caption = "Hide" Else ToggleButton1.Caption = "Show" End If End Sub You might have to flip the logic I used. Also, better to use a range name for cell G8 so if you insert a row, etc., the code still works. -- Jim "gtslabs" wrote in message ... |I am trying to use CF to hide some cells (actually turning the font | color white). | I made a Control Toggle Button and linked it to cell G8. | | The cells I want to hide are say B2...B6 | I select that range and goto Conditional Formating | | 2 Questions: | | 1) How do I write the "formula is" CF expression testing if G8 is TRUE | or FALSE? | I tried G8=TRUE but that is not working. | | 2)How do I change the caption of the Toggle Button to show different | text if depressed or not. | So I want it to say SHOW and HIDE |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
CF using Toggle Button result
On the issue of Formula Is, you need $$ because the formula in CF is
copied identically to cell formulas. =$G$8=TRUE HTH Kostis Vezerides On Nov 25, 4:52*pm, gtslabs wrote: I am trying to use CF to hide some cells (actually turning the font color white). I made a Control Toggle Button and linked it to cell G8. The cells I want to hide are say B2...B6 I select that range and goto Conditional Formating 2 Questions: 1) How do I write the "formula is" CF expression testing if G8 is TRUE or FALSE? I tried G8=TRUE but that is not working. 2)How do I change the caption of the Toggle Button to show different text if depressed or not. So I want it to say SHOW and HIDE |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
CF using Toggle Button result
Do you need the =TRUE? Wouldn't =$G$8 do it?
-- David Biddulph "vezerid" wrote in message ... On the issue of Formula Is, you need $$ because the formula in CF is copied identically to cell formulas. =$G$8=TRUE HTH Kostis Vezerides On Nov 25, 4:52 pm, gtslabs wrote: I am trying to use CF to hide some cells (actually turning the font color white). I made a Control Toggle Button and linked it to cell G8. The cells I want to hide are say B2...B6 I select that range and goto Conditional Formating 2 Questions: 1) How do I write the "formula is" CF expression testing if G8 is TRUE or FALSE? I tried G8=TRUE but that is not working. 2)How do I change the caption of the Toggle Button to show different text if depressed or not. So I want it to say SHOW and HIDE |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
CF using Toggle Button result
Personally I would not put it but I thought that I should maintain the
philosophy the OP used for his formula. To the OP: Anything numeric and non-zero counts as TRUE in logical context. Hence, especially since your formula in G8 is logical and returns TRUE/FALSE, it would be enough to use the simplified formula as David suggested. Kostis On Nov 25, 6:13*pm, "David Biddulph" <groups [at] biddulph.org.uk wrote: Do you need the =TRUE? *Wouldn't =$G$8 do it? -- David Biddulph "vezerid" wrote in message ... On the issue of Formula Is, you need $$ because the formula in CF is copied identically to cell formulas. =$G$8=TRUE HTH Kostis Vezerides On Nov 25, 4:52 pm, gtslabs wrote: I am trying to use CF to hide some cells (actually turning the font color white). I made a Control Toggle Button and linked it to cell G8. The cells I want to hide are say B2...B6 I select that range and goto Conditional Formating 2 Questions: 1) How do I write the "formula is" CF expression testing if G8 is TRUE or FALSE? I tried G8=TRUE but that is not working. 2)How do I change the caption of the Toggle Button to show different text if depressed or not. So I want it to say SHOW and HIDE |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Toggle Button | Excel Worksheet Functions | |||
Need to Use 1 Button to toggle On or Off | Excel Discussion (Misc queries) | |||
Toggle Button | Excel Discussion (Misc queries) | |||
Toggle button | Excel Discussion (Misc queries) | |||
Toggle Button | Excel Discussion (Misc queries) |