| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Prompt for text entry in Cell B2
Please help me with a macro or vb to prompt the user for
and then accept the text entry for the user's organization in cell B2 on a worksheet. Regards, JA |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Prompt for text entry in Cell B2
Sub test()
Range("a2").Value = InputBox("user's organization") End Sub "jamesa" wrote in message ... Please help me with a macro or vb to prompt the user for and then accept the text entry for the user's organization in cell B2 on a worksheet. Regards, JA |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Prompt for text entry in Cell B2
Thanks Cole. It works.
-----Original Message----- Sub test() Range("a2").Value = InputBox("user's organization") End Sub "jamesa" wrote in message ... Please help me with a macro or vb to prompt the user for and then accept the text entry for the user's organization in cell B2 on a worksheet. Regards, JA . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| visual basic prompt data entry | Excel Discussion (Misc queries) | |||
| Restrict cell entry until another cell has random text | Excel Discussion (Misc queries) | |||
| Change Text Color in one cell based upon entry in referenced cell | Excel Discussion (Misc queries) | |||
| How prompt Excel user to fill cell with text, i.e., proposal name | Excel Discussion (Misc queries) | |||
| Add/Replicate Text In Cell Entry | Excel Worksheet Functions | |||
Linear Mode
