Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Type mismatch...
When running the following Visual Basic code a run time error occurs
saying that there is a type mismatch. The name txtRemoveSheet is from a textbox. My assumption was that it should be of type string and that the Delete method accepted strings. Is this assumption correct? I don't see why txtRemoveSheet is not accepted, can someone enlighten me? Private Sub cmdDelete_Click() Worksheets(txtRemoveSheet).Delete txtRemoveSheet.Text = "" End Sub Thank you, George |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Type Mismatch | Excel Worksheet Functions | |||
Sumif from VBA Type mismatch | Excel Worksheet Functions | |||
run-time 13 Type mismatch | Excel Discussion (Misc queries) | |||
Type Mismatch Error | Excel Discussion (Misc queries) | |||
type mismatch--how to fix | Excel Discussion (Misc queries) |