View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
carlo carlo is offline
external usenet poster
 
Posts: 367
Default 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?