View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
cogent cogent is offline
external usenet poster
 
Posts: 32
Default Pulling Array from InputBox

Hello

I would like a default "array" in my input box:

vLBDays = Application.InputBox(Prompt:="Enter LB horizons (in rollovers):",
Title:="Lookback Horizons", Default:="{05,10,20}", Type:=64)

but I cannot get it to work without the brackets. If the user wants
anything other than the default values, he must include brackets which is
annoying and time consuming.

Any ideas?

W