Prompt for text entry in Cell B2

[jamesa]

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

 

[Cole]

Sub test()
Range("a2").Value = InputBox("user's organization")
End Sub

 

[jamesa]

Thanks Cole. It works.

-----Original Message-----
Sub test()
Range("a2").Value = InputBox("user's organization")
End Sub




.