Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Prompting users for data entry in a worksheet
Hi,
Can anyone tell me how to record or program a macro that will prompt the user with a question for a cell (eg" What is the Client's name?") so they can enter the text which will be the content of the cell? Thanks very much. Michelle. |
#2
|
|||
|
|||
You could use a macro:
Option Explicit sub GetName() worksheets("sheet1").range("a1").value _ = inputbox(Prompt:="What is the client's name?") end sub You could even call this routine Auto_Open(). Then it'll run as soon as the workbook opens. But if you're gonna start getting lots of info from the user, you may want to use a UserForm. Debra Dalgleish has a small tutorial at: http://contextures.com/xlUserForm01.html Or just use cells in the workbook (with nice descriptions in the adjacent cells). MG wrote: Hi, Can anyone tell me how to record or program a macro that will prompt the user with a question for a cell (eg" What is the Client's name?") so they can enter the text which will be the content of the cell? Thanks very much. Michelle. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I protect a worksheet yet allow editing in Excel 2000 | Excel Discussion (Misc queries) | |||
Comparing a list to a Calendar worksheet. | Excel Worksheet Functions | |||
copyright and worksheet protection | Excel Discussion (Misc queries) | |||
Executing macro for all worksheet from a different worksheet | New Users to Excel | |||
Worksheet name and Backward compatibility | Excel Discussion (Misc queries) |