Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello Board
I would like the default value of the Input box to be the array: 10,20,40 and of course the user may specify an array of his own. But I cannot get the Array values to be accepted by this method and I cannot figure out why: Dim vAggregations As Variant vAggregations = Application.InputBox(Prompt:="Enter LB horizons (in rollovers):", Title:="Lookbacks", Default:=Array("10,20,40"), Type:=64) If the user wishes to accept the default values, pressing OK on the Dialog box does nothing. The box remains there apparently still waiting for input. What am I doing wrong? Thank you W |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Please post this thread a correct full method, method about | New Users to Excel | |||
Detecting Cancel in an InputBox Method | Excel Discussion (Misc queries) | |||
Inputbox method using type:=8 - How to Cancel? | Excel Programming | |||
Inputbox method using type:=8 - How to Cancel? | Excel Programming | |||
Inputbox method using type:=8 - How to Cancel? | Excel Programming |