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

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

Check your other post, too.

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

--

Dave Peterson

hiya,

thanks a lot for that but it doent seem to work with the version of excel i
am using, i am using microsoft office excel 2002. do i need to update the
software before being able to do this?? when i right click on the check box,
the only options are cut, copy, paste, edit text, grouping, order, assign
macro, and format control.

Hope this makes it clearer.

Thanks again

"Shane Devenshire" wrote:

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

it isn't the version of excel that's the problem, it's the checkbox.
there are two kinds of controls - Forms controls and ActiveX Control
Toolbox controls. the kind you are describing are forms controls.
shane told you that he was using a control toolbox control. at the
top of your spreadsheet right-click and check "control toolbox". that
toolbar will appear. use the checkbox from THAT toolbar.
hope that helps!
:)
susan



On Feb 17, 11:46*am, Adam H wrote:
hiya,

thanks a lot for that but it doent seem to work with the version of excel i
am using, i am using microsoft office excel 2002. do i need to update the
software before being able to do this?? when i right click on the check box,
the only options are cut, copy, paste, edit text, grouping, order, assign
macro, and format control.

Hope this makes it clearer.

Thanks again



"Shane Devenshire" wrote:
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- Hide quoted text -

- Show quoted text -

hello again,
Thank you for the help!! it worked perfectly!!
however, one more little problem, i saved my work and shut down, but when i
went to reopen and use the check box functions, a help box came up saying
that "to run the macros, you can either have them signed or change your
security level." now i changed my security level to low, and this still did
not help,
Any suggestions on how to solve this problem?

Thank you very much.

Adam


"Susan" wrote:

it isn't the version of excel that's the problem, it's the checkbox.
there are two kinds of controls - Forms controls and ActiveX Control
Toolbox controls. the kind you are describing are forms controls.
shane told you that he was using a control toolbox control. at the
top of your spreadsheet right-click and check "control toolbox". that
toolbar will appear. use the checkbox from THAT toolbar.
hope that helps!
:)
susan



On Feb 17, 11:46 am, Adam H wrote:
hiya,

thanks a lot for that but it doent seem to work with the version of excel i
am using, i am using microsoft office excel 2002. do i need to update the
software before being able to do this?? when i right click on the check box,
the only options are cut, copy, paste, edit text, grouping, order, assign
macro, and format control.

Hope this makes it clearer.

Thanks again



"Shane Devenshire" wrote:
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- Hide quoted text -

- Show quoted text -