Tick Box and Command Button

[Lynxboy252]

Hi there,

Can anyone tell me if it's possible to use tick boxes to show and hide a
command button?

If a tickbox is ticked, the button appears. If there isn't a tick in the
box, the command button isn't visible.

If this is possible or there is code to do this, can someone be of
assistance? If code is supplied, generic names can be used, I'm okay with
renaming parts of the code.

Any help would be very much appreciated.

Regards,

Adam

 

[m3]

Try this code as your CheckBox's After Update Event procedure:-

Private Sub CheckBox_AfterUpdate()
If CheckBox.Value = True Then
CommandButton.Visible = True
Else
CommandButton.Visible = False
End If
End Sub