ipbr21054
Well-known Member
- Joined
- Nov 16, 2010
- Messages
- 5,683
- Office Version
- 2007
- Platform
- Windows
Afternoon,
When i open my worksheet my last search is still shown in the Combobox.
I would like it to be clear with nothing shown when i open my worksheet etc.
I have tried this code below but i see a error message object does not support this method.
Debuge tells me the line not supported is With ThisWorkBook etc
Please can you advise the correct way to clear upon opening.
Have a nice day
When i open my worksheet my last search is still shown in the Combobox.
I would like it to be clear with nothing shown when i open my worksheet etc.
I have tried this code below but i see a error message object does not support this method.
Debuge tells me the line not supported is With ThisWorkBook etc
Please can you advise the correct way to clear upon opening.
Code:
Private Sub Workbook_Open()With ThisWorkbook.Sheets("DATABASE").ComboBox1
.SelectedIndex = -1
End With
End Sub
Have a nice day