Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 77
Default 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!
  #2   Report Post  
Posted to microsoft.public.excel.programming
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!



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 77
Default 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!
  #4   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default 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!
.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Default Windows Profile without default Office user info Karen Excel Discussion (Misc queries) 0 November 12th 08 04:53 PM
Calculator Answer Doesn't Match Excel Answer GwenH Excel Discussion (Misc queries) 3 October 20th 08 10:17 AM
If total answer is over default of 160 then 160, otherwise the formula i have works great! [email protected] Excel Worksheet Functions 6 March 16th 07 09:05 AM
Pivot table - default answer keith Excel Discussion (Misc queries) 0 March 22nd 06 11:12 AM
i cant get the exact answer e.g answer is 13.49% i got 13.00% zai Excel Discussion (Misc queries) 3 June 9th 05 01:00 PM


All times are GMT +1. The time now is 05:28 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"