naming my worksheet

[Charlie]

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?

 

[carlo]

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