Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Prompt user for input and utilize that input
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Prompt user for input and utilize that input
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Prompt user for input and utilize that input
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 "Dave F" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Looking for help with user input variable€¦ | Excel Discussion (Misc queries) | |||
Have user input converted to uppercase in same cell as input? | New Users to Excel | |||
Having a Macro Prompt Me For Input | Excel Worksheet Functions | |||
Ask user for input during marco | Excel Discussion (Misc queries) | |||
INDEX, user input? | Excel Worksheet Functions |