ipbr21054
Well-known Member
- Joined
- Nov 16, 2010
- Messages
- 5,226
- Office Version
- 2007
- Platform
- Windows
Hi,
I have a userform where i have two TextBoxes that may clash.
So i am trying to write something that doesnt show one if the other has a value.
Basically if TB1 is empty then show TB10 but if TB1 has a value then TB10 hiden
I tried this but wasnt hidden when i wrote a value
I have a userform where i have two TextBoxes that may clash.
So i am trying to write something that doesnt show one if the other has a value.
Basically if TB1 is empty then show TB10 but if TB1 has a value then TB10 hiden
I tried this but wasnt hidden when i wrote a value
Rich (BB code):
Private Sub TextBox6_Change()
If TextBox6.Value = True Then
TextBox10.Visible = False
End If
End Sub