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?

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?