Arrays in VBA

[Adamba]

Hiya all,

Would anyone know how to set up and use an array in VB?
What i am trying to do is set up a 'phone pad' style Coding System.

E.g.

the Array would assign Letters to a Number:
A,B,C ->2
D,E,F ->3
G,H,I ->4
etc.

then to code an input string as numbers:

Adam -> 2326

Thanks in advance.

Adam

 

[SkipVought]

Hi,

Arrays - check in help
First you Dim you array with the number of elements and dimensions
Then you assign values
For instance...

Dim Myarray(2)
MyArray(0) = value1
MyArray(1) = value2

BUT...
in your requirement, i would not necessarily use an array for this application. I would use Select Case as follows...

Select Case DialButtonValue
   Case "A", "B", "C"
      NumValue = 2
   Case "D", "E", "F"
      NumValue = 3
...etc
End Select

All kinds of ways to skin a cat... Skip,
metzgsk@voughtaircraft.com