Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Default Windows Profile without default Office user info | Excel Discussion (Misc queries) | |||
Calculator Answer Doesn't Match Excel Answer | Excel Discussion (Misc queries) | |||
If total answer is over default of 160 then 160, otherwise the formula i have works great! | Excel Worksheet Functions | |||
Pivot table - default answer | Excel Discussion (Misc queries) | |||
i cant get the exact answer e.g answer is 13.49% i got 13.00% | Excel Discussion (Misc queries) |