This seems to be a bit of a misnomer to me. Arrays are treated as a single variable in VB; the only difference is that it’s indexed internally. If you wish to input the entire alphabet into an array in the correct order so as to produce the expected result of a =1 b=2 (or the reverse) you would have to sort all the letters prior to pushing them into the array. This is kind of like doing the same equation twice and is best avoided, however this does have its place where huge amounts of comparisons need to be done quickly with little output translation or to push straight into another function. This is a complex subject and one reason why I mostly design my own arrays that can accept any data type as apposed to visual basics single data type.
These should have made illegal years ago. Whilst there may be the occasional use that might have been justified ten years ago I can’t see any use for them in a modern computer language as is you have to “strap-up” one set of variables and then compare the with another, your programme is badly designed or even not thought through.
Unfortunately everyone here is right, there isn't a built in function to sort alphabetically in Visual Basic. However, a sub routine can easily be built to do it. There are a few different ways of doing it, one of the most popular is known as a 'Bubble Sort'
Dim indexLimit As Long, lastSwap As Long
Dim firstItem As Long
Dim index As Long
Dim value As Variant
indexLimit = UBound(theArray) - 1
lastSwap = 0
For index = firstItem To indexLimit
value = theArray(index)
If (value > theArray(index + 1)) Then
theArray(index) = theArray(index + 1)
theArray(index + 1) = value
lastSwap = index
Loop While lastSwap
For i = 0 To UBound(theArray) - 1
testing(i) = theArray(i)
Ep, glad to see you come back and tidy up...did want to ask a one day favor, I want to enhance my resume , was hoping you could make me administrator for a day, if so, take me right off since I won't be here to do anything, and don't know the slightest about the board, but it would be nice putting "served administrator osnn", if can do, THANKS