Can anyone advise me the macro code to create a msg box having a space
for the user to input a text string which can then be used for
subsequent processing?
Thanks, Exdevon


--
Exdevon
------------------------------------------------------------------------
Exdevon's Profile: http://www.excelforum.com/member.php...o&userid=32108
View this thread: http://www.excelforum.com/showthread...hreadid=518654

It's not the Msgbox() statement you need, it's
Input() that you need, like so..
In VBA code
ans = Input("Enter your Name") << see help for more


"Exdevon" wrote in
message ...

Can anyone advise me the macro code to create a msg box having a space
for the user to input a text string which can then be used for
subsequent processing?
Thanks, Exdevon


--
Exdevon
------------------------------------------------------------------------
Exdevon's Profile:
http://www.excelforum.com/member.php...o&userid=32108
View this thread: http://www.excelforum.com/showthread...hreadid=518654

Hi Exdevon,
Use either VB's InputBox function or Excel's Application.Inputbox
function.
Application.InputBox is convenient because you can specify the input
with the Type argument, Type:=2 causes input that is not text string to
be rejected.
Ken Johnson