Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
naming my worksheet
I have a tabstrip on my userform to set the current sheet:
Private Sub TabStrip1_Change() wsMyWorksheet = Worksheets("Sheet" & Me.TabStrip1.Value +1) ....but this doesn't work because it's combining a string with a number, I think. How would I asign wsMyWorksheet to "sheetx" where x is the value of tabstrip plus 1? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
naming my worksheet
The combination of a number with a string shouldn't be a problem.
I think what you forgot is the "set" statement: Private Sub TabStrip1_Change() dim wsMyWorksheet as worksheet set wsMyWorksheet = Worksheets("Sheet" & Me.TabStrip1.Value +1) end sub hth Carlo On Dec 26, 2:00*pm, Charlie wrote: I have a tabstrip on my userform to set the current sheet: Private Sub TabStrip1_Change() wsMyWorksheet = Worksheets("Sheet" & Me.TabStrip1.Value +1) ...but this doesn't work because it's combining a string with a number, I think. *How would I asign wsMyWorksheet to "sheetx" *where x is the value of tabstrip plus 1? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Worksheet naming | Excel Discussion (Misc queries) | |||
Naming A Worksheet | Excel Programming | |||
Naming worksheet | Excel Programming | |||
Naming Worksheet | New Users to Excel | |||
Naming a worksheet help? | Excel Worksheet Functions |