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