You can create a macro in a module, such as the following, and assign it to a
button:

Sub UseButton()
Dim InString As String
Sheets("Sheet1").Range("A1").Value = Application.InputBox("Enter file
name here")
Range("A2").Select
End Sub

The button, when clicked, displays the message "Enter file name here" and
returns the user input into cell A1.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"ninner" wrote:

I've been reading previous posts, not found what I need and am worried about
a new task I've been assigned. I need to prompt a user for a worksheet name
after the user clicks on a button and when the name is entered, it will be
entered on the sheet tab, in cell A1 of that worksheet and into a cell on a
summary sheet located in another part of the workbook.

I have no idea where to start and I'm not a programmer.

All help is desperately needed!
Ninner