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?
|