Hi,
I am trying to use macro which changes textbox depending of another textbox.
If I use this specific macro, if my textbox is empty, why 2nd one don't want to clear value?
This code doesn't provide anything nor affecting that another textbox.
Event where I use it:
I am trying to use macro which changes textbox depending of another textbox.
If I use this specific macro, if my textbox is empty, why 2nd one don't want to clear value?
Code:
If IsEmpty(Me.txtMaterial) Then
Me.txtCreator.Value = ""
Me.txtAction.Value = ""
Me.txtDelegated.Value = ""
Exit Sub
End If
Event where I use it:
Code:
Private Sub txtMaterial_Change()