Hi
How do I set the default value for an input box to the value in F13 on
"mysheet"

Thanks

Sandy,

Look up "InputBox" in VBA Help.

The arguments for the InputBox function a
-prompt
-title
-default
-xpos
-ypos
-helpfile
-context

....in that order

"prompt" is the message to the user inside the box.
"title" is what shows up in the title bar of the textbox.
"default" is the default value in the box.

for example:
pstrAnswer = InputBox("Please enter a value:", "Value Needed","This is the
default value")

HTH,

Conan




"Sandy" wrote in message
...
Hi
How do I set the default value for an input box to the value in F13 on
"mysheet"

Thanks

myVar = InputBox("Your Prompt Here", "Dialog Box Title Here", _
Default:=Range("F13").Value)

"Sandy" wrote:

Hi
How do I set the default value for an input box to the value in F13 on
"mysheet"

Thanks

More explicit:

myVar = InputBox("Your Prompt Here", "Dialog Box Title Here", _
Default:=mySheet.Range("F13").Value)

"Sandy" wrote:

Hi
How do I set the default value for an input box to the value in F13 on
"mysheet"

Thanks