View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz JLGWhiz is offline
external usenet poster
 
Posts: 3,986
Default Input Box Default Value

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