Hi,
I'm making a program in VBA where the user enters 20 ages / numbers in inputboxes, and then all these ages / numbers should be printed in a textbox and also be sorted ascending. I think it's ascending, it's like
x < y< z < ...
Code:
Option Compare Database
Option Explicit
Private Sub Form_Load()
Dim intAges(20) As Integer
Dim intInputAges As Integer
Dim i As Integer
For i = 1 To 20
intInputAges = InputBox("Geef een leeftijd in.", "Leeftijd", "Leeftijd")
intAges(i) = intInput
Next i
txtAges.SetFocus
End Sub
This is what I got so far. I wouldn't have a clue about how to sort them, and in the help file I only find SQL statements like ORDER BY.
Thanks for all feedback.
edit: I know that in visual basic .NET arrays start counting on zero, is it the same here or is it ok as I wrote it?