T
Thunder5
I'm creating a Userform which includes manufacture dates and shelf
life.
I have a Checkbox and a Textbox that I would like to have work
together.
I would like the Checkbox unchecked on startup and the associated
Textbox to be disabled unless the Checkbox is checked.
The code currently reads:
Private Sub chkExtension_Change()
If chkExtension = True Then
ActiveCell.Offset(0, 15).Value = "Yes"
Else
ActiveCell.Offset(0, 15).Value = "NO"
End If
If chkExtension = True Then
txtExtDate.Enabled = True
Else
chkExtension.Enabled = False
txtExtDate.Enabled = False
End If
End Sub
life.
I have a Checkbox and a Textbox that I would like to have work
together.
I would like the Checkbox unchecked on startup and the associated
Textbox to be disabled unless the Checkbox is checked.
The code currently reads:
Private Sub chkExtension_Change()
If chkExtension = True Then
ActiveCell.Offset(0, 15).Value = "Yes"
Else
ActiveCell.Offset(0, 15).Value = "NO"
End If
If chkExtension = True Then
txtExtDate.Enabled = True
Else
chkExtension.Enabled = False
txtExtDate.Enabled = False
End If
End Sub