Tick Box and Command Button

  • Thread starter Thread starter Lynxboy252
  • Start date Start date
L

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
 
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
 
Back
Top