Pop-up Windows

[Skarab]

Hi board,

I'm working on a worksheet and what i'm looking to do is to have a button which a user can use to unhide a sheet. this itself is simple enough, but what i'd like to do is to have a pop-up window appear immediately after the button is pressed asking the user what he/she would like the sheet (which is about to appear) to be called. once the user then enters this name into the pop-up window, cell A1 on the new sheet will be named as per the users request.

i've had a bit of a look and can't find anything on how to do this, can anyone help or propose a different method by which i can get the same result?

much appreciated,
Skarab

 

[VoG]

Try like this

Private Sub CommandButton1_Click()
With Sheets("Sheet1")
    .Visible = xlSheetVisible
    .Range("A1").Value = InputBox("Enter name")
End With
End Sub

 

[Skarab]

Thanks VoG,

Very helpful, very prompt!!!