Input Box Default Value

[Sandy]

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

Thanks

 

[Conan Kelly]

Sandy,

Look up "InputBox" in VBA Help.

The arguments for the InputBox function are:
-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

 

[JLGWhiz]

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

 

[JLGWhiz]

More explicit:

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