Hi,
To Dave Peterson,
I found something else... During my previous trials to get an Array with
Type:=64, after some erratic entries, I got a warning of error about an
invalid "matricial value". It gave me an idea.
Now here is my new Sub :
Sub Essai()
Dim Tableau As Variant
Tableau = Application.InputBox("Essai", Type:=64)
MsgBox Tableau(1)
MsgBox Tableau(2)
MsgBox Tableau(3)
End Sub
It works if in the InputBox I write a matrix such as : {"AA"."BB"."CC"}
There are curly braces around the values and a full stop between each item.
In this manner I can enter as many items as I want.
The LowerBound of the array is 1, though I did not fix it anywhere. The Sub
works for String entries and numeric entries {10.20.30}. I could not enter
dates in any format.
Good evening
B.Caneau