ipbr21054
Well-known Member
- Joined
- Nov 16, 2010
- Messages
- 5,226
- Office Version
- 2007
- Platform
- Windows
Hi,
Im not sure if im aproaching this the correct way so could you advise please.
I open my userform which has 5 TextBoxes & a ListBox.
If i click in a TextBox & type a partial value say AB the results are then shown in the ListBox.
It is now that i wish to click in a different TextBox.
Upon clicking in the other TextBox i wish for the other TextBoxes to be all cleared.
Once ive managed to get this working i will then look to also clear the values in the ListBox
I have tried the below but nothing happens at all when i select the other TextBox
Thanks
Im not sure if im aproaching this the correct way so could you advise please.
I open my userform which has 5 TextBoxes & a ListBox.
If i click in a TextBox & type a partial value say AB the results are then shown in the ListBox.
It is now that i wish to click in a different TextBox.
Upon clicking in the other TextBox i wish for the other TextBoxes to be all cleared.
Once ive managed to get this working i will then look to also clear the values in the ListBox
I have tried the below but nothing happens at all when i select the other TextBox
Rich (BB code):
Private Sub TextBoxName_Click()
If TextBoxName.Value <> "" Then
TextBoxReg.Value = ""
TextBoxVehicle.Value = ""
TextBoxKeyCode.Value = ""
TextBoxChassisNumber.Value = ""
End If
End Sub
Thanks