ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   msg box - default answer (https://www.excelbanter.com/excel-programming/323432-msg-box-default-answer.html)

Michael Smith

msg box - default answer
 
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!

JulieD

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!




No Name

msg box - default answer
 
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.

-----Original 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!
.


Michael Smith

msg box - default answer
 

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


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


All times are GMT +1. The time now is 02:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com