Tark221
Registered User.
- Local time
- Today, 23:12
- Joined
- Oct 12, 2012
- Messages
- 74
Private Sub delete_Click()
staffName = DelF.ComboBox3
Sheets(staffName).Select
ActiveWindow.SelectedSheets.delete
End Sub
This is my code - there is some code which i havent pasted which dependant on what you pick in drop down 1 depends what you get in drop down 2 (ComboBox3)
then the code above runs
if i replace the combobox3 with a textbox and enter what worksheet i want to delete works fine but I thought id replace it with a combo box for convenience, when i select the sheet i want to delete, it doesnt work, If I hit backspace on the combo box to manually enter the sheets name instead of clicking from the drop down list it works, so weird any suggestions
staffName = DelF.ComboBox3
Sheets(staffName).Select
ActiveWindow.SelectedSheets.delete
End Sub
This is my code - there is some code which i havent pasted which dependant on what you pick in drop down 1 depends what you get in drop down 2 (ComboBox3)
then the code above runs
if i replace the combobox3 with a textbox and enter what worksheet i want to delete works fine but I thought id replace it with a combo box for convenience, when i select the sheet i want to delete, it doesnt work, If I hit backspace on the combo box to manually enter the sheets name instead of clicking from the drop down list it works, so weird any suggestions
