msg box - default answer

[Michael Smith]

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

 

[JulieD]

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

 

[Guest]

hi,
you mean inputbox don't you?

MyValue = InputBox(Message, Title, Default)

all a message box does is display a message.
read up on the inputbox function and inputbox method in vb
help. you will have to access it through the vb editor.
regular excel help will tell you it doesn't know what you
mean.

 

[Michael Smith]

Thank you! Didn't have my vb bible with me and needed this in a bind.
Thanks all.