View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JulieD JulieD is offline
external usenet poster
 
Posts: 618
Default msg box - default answer

Hi

if you use an INPUTBOX the third parameter is a default answer
e.g.
strrsp = INPUTBOX("Enter favourite number.","Lucky Numbers",5)

Cheers
JuileD

"Michael Smith" wrote in message
...
Hey all, I have a msgbox that prompts the user for a desired number. I
want the number 5 to appear in the answer box and highlited...basically
setting a default answer AND highliting it so as to allow it to be
copied over if the user desides to type a different number. Can this be
done?

Thanks in advance.
-mike


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!