Prompt user for input and utilize that input

G

Guest

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
 
G

Guest

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
 
G

Guest

Thank you Dave!

Though not being a programmer, I'm not sure this is the only code I'd need.
Once the sheet is named (I gather that is done with the
"Sheets("Sheet1").Range("A1").Value = Application.InputBox("Enter file name
here")" and the name put in A1 of that sheet, what puts the same name in the
1st blank cell in column A on the summary sheet (another worksheet in the
came workbook)? Will I first have to search for a blank cell on the Summary
worksheet and then insert the string (which I gather is Application.InputBox)?

Ninner
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top