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

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

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


.