Results 1 to 2 of 2

Thread: Arrays in VBA

  1. #1
    Join Date
    Nov 2006

    Unanswered: Arrays in VBA

    Sorry for asking pretty simple question:
    Where is a good place to learn basics for making arrays in VBA?
    Im doing this thing where i simulate customer shopping and checkout times in a store and i will need to record each time when a customer waited for less than three minutes and also for more than three minutes. Then i will need to pull that data out and report how many times customers had to wait for more than three minutes before they could proceed to the checkout. There's only one checker, and i have all the functions needed for generating customer arrival, shopping times.

    id appreciate any help

  2. #2
    Join Date
    Nov 2006
    North of San Francisco
    Something to start with
    Dim array1(10, 10) As String
    Private Sub Form_Load()

    For row = 0 To 10
    For col = 0 To 10
    array1(row, col)=str(row) & str(Col)
    Next col
    Next row

    End Sub

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts