Opening a spreadsheet using a form

[tazz]

Hello all,
I have a workbook with a lot of spreadsheets and I created a small form to open the spreadsheet that I type in textbox. This form has only 1 text box and 1 cmdbutton.
This is the code I used for the cmd button:


Private Sub cmdOpen_Click()
ActiveWorkbook.Sheets("Sheet").Activate
Sheet.value=txtPiece.value
Unload Me
End Sub

I have a message of error and I know that is something wrong with line 2 but I don't know exactly what.
Any suggestions?
Thank you.

 

[Abhijeet R. Joshi]

I think the below should help you..

try using this..

Private Sub CommandButton1_Click()
dx = UserForm1.TextBox1.Value
Sheets(dx).Select
Unload Me
End Sub

 

[tazz]

Thanks Abhi,
Is working really nice.