Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional visibility of check box
Hi All,
I want to use check box from control toolbar. I want this check box to be visible if there is a certain value in another cell. Is this possible somehow? Thanks in advance, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional visibility of check box
As opposed to conditional visibility I prefer to use conditional enabling.
The box is there but can not be used until the cell is filled in. I get too many calls from people saying it is broken because the check box was not there... Tyr this Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Me.Range("A1"), Target) Is Nothing Then If Target.Value < "" Then CheckBox1.Enabled = True Else CheckBox1.Enabled = False End If End If End Sub Paste this code into the sheet where the checkbox is. -- HTH... Jim Thomlinson "Erol" wrote: Hi All, I want to use check box from control toolbar. I want this check box to be visible if there is a certain value in another cell. Is this possible somehow? Thanks in advance, |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional visibility of check box
That was awesome, thank you Jim.
I would appreciate if you can also show me how to make it visible and invisible under a cell's condition. Thank you "Jim Thomlinson" wrote: As opposed to conditional visibility I prefer to use conditional enabling. The box is there but can not be used until the cell is filled in. I get too many calls from people saying it is broken because the check box was not there... Tyr this Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Me.Range("A1"), Target) Is Nothing Then If Target.Value < "" Then CheckBox1.Enabled = True Else CheckBox1.Enabled = False End If End If End Sub Paste this code into the sheet where the checkbox is. -- HTH... Jim Thomlinson "Erol" wrote: Hi All, I want to use check box from control toolbar. I want this check box to be visible if there is a certain value in another cell. Is this possible somehow? Thanks in advance, |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional visibility of check box
Replace Enable with Visible in the code that was posted...
CheckBox1.Visible= True or False... -- HTH... Jim Thomlinson "Erol" wrote: That was awesome, thank you Jim. I would appreciate if you can also show me how to make it visible and invisible under a cell's condition. Thank you "Jim Thomlinson" wrote: As opposed to conditional visibility I prefer to use conditional enabling. The box is there but can not be used until the cell is filled in. I get too many calls from people saying it is broken because the check box was not there... Tyr this Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Me.Range("A1"), Target) Is Nothing Then If Target.Value < "" Then CheckBox1.Enabled = True Else CheckBox1.Enabled = False End If End If End Sub Paste this code into the sheet where the checkbox is. -- HTH... Jim Thomlinson "Erol" wrote: Hi All, I want to use check box from control toolbar. I want this check box to be visible if there is a certain value in another cell. Is this possible somehow? Thanks in advance, |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional visibility of check box
This is magic.... thank you Jim
"Erol" wrote: That was awesome, thank you Jim. I would appreciate if you can also show me how to make it visible and invisible under a cell's condition. Thank you "Jim Thomlinson" wrote: As opposed to conditional visibility I prefer to use conditional enabling. The box is there but can not be used until the cell is filled in. I get too many calls from people saying it is broken because the check box was not there... Tyr this Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Me.Range("A1"), Target) Is Nothing Then If Target.Value < "" Then CheckBox1.Enabled = True Else CheckBox1.Enabled = False End If End If End Sub Paste this code into the sheet where the checkbox is. -- HTH... Jim Thomlinson "Erol" wrote: Hi All, I want to use check box from control toolbar. I want this check box to be visible if there is a certain value in another cell. Is this possible somehow? Thanks in advance, |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional visibility of check box
Hi Jim... your previous replies helped greatly.... but I was trying the check
box clickable when A1 cell has the exact value of "2". Is this possible.... I substituted (< "") with ( = 2) or even with ( = "2") but it didn't work. The value 2 is an output of an option button. I would appreciate the help. "Jim Thomlinson" wrote: Replace Enable with Visible in the code that was posted... CheckBox1.Visible= True or False... -- HTH... Jim Thomlinson "Erol" wrote: That was awesome, thank you Jim. I would appreciate if you can also show me how to make it visible and invisible under a cell's condition. Thank you "Jim Thomlinson" wrote: As opposed to conditional visibility I prefer to use conditional enabling. The box is there but can not be used until the cell is filled in. I get too many calls from people saying it is broken because the check box was not there... Tyr this Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Me.Range("A1"), Target) Is Nothing Then If Target.Value < "" Then CheckBox1.Enabled = True Else CheckBox1.Enabled = False End If End If End Sub Paste this code into the sheet where the checkbox is. -- HTH... Jim Thomlinson "Erol" wrote: Hi All, I want to use check box from control toolbar. I want this check box to be visible if there is a certain value in another cell. Is this possible somehow? Thanks in advance, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Add-In Visibility | Excel Discussion (Misc queries) | |||
Check if Conditional Format is True or False / Check cell Color | Excel Worksheet Functions | |||
Textbox text visibility | Excel Discussion (Misc queries) | |||
Custom Toolbar Visibility | Excel Discussion (Misc queries) | |||
Visibility of active cell. | Excel Discussion (Misc queries) |