Thread: Check Boxes
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
 
Posts: 3,346
Default Check Boxes

Hi,

You only told us how you show the button not how/when to hide it. Here is
code you would attach to one button to show the other button:

Private Sub CommandButton2_Click()
ActiveSheet.Shapes("CommandButton1").Visible = True
End Sub

This is a Control Toolbox button. CommandButton1 was set to Visible = False
manually and then the code was run.
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Adam H" wrote:

Hiya,

I need to set up two check boxes in excel.
The first box needs to be there, on show, all the time, but the second only
needs to appear once the first has been ticked.
Is this possible??

Thanks you for taking the time to read and reply to this,

Adam