Brian, There are 2 examples here: http://support.microsoft.com/default.aspx/kb/210442
You can also download all the VBA references here: http://www.microsoft.com/technet/scriptcenter/topics/office/vba.mspx Here is a simplified example: Dim myArray(4) 'zero based array with 5 elements myArray(0) = "Array element 0" myArray(1) = "Array element 1" myArray(2) = "Array element 2" myArray(3) = "Array element 3" myArray(4) = "Array element 4" For a = 0 to 4 Debug.Print myArray(a) Next a ' output should look like this Array element 0 Array element 1 Array element 2 Array element 3 Array element 4 I don't program in VB for Apps that Boston uses as I use VB.Net but I believe the following should also work to load an array. Dim myArray("element0", "element1", "element2") I hope this helps. >>> On 2/20/2009 at 10:16 AM, in message <[email protected]> wrote: > Thanks for all the info and idears (as senior would say). On the Arrays, do > you have a decent site I could visit? I am very array challenged. I don't > mind updating the code every time I update the array. > > Thanks. > > > Brian Bennett > Affinity Health Systems > Systems Analyst > PBS\Clinic Billing > (920)628-9055 > [email protected] > > -----Original Message----- > From: [email protected] [mailto:[email protected]] > Sent: Friday, February 20, 2009 11:50 AM > To: [email protected] > Subject: [talkbws] RE: Whats better than Select Case? > > In vb a select case statement is much more efficient than a series of If > Then statements. You can create arrays in vb which should be slightly more > efficient than select case if the program was running continuously for a > considerable time. The difference would be negligible unless you had > hundreds or thousands of values. > > Both select case or an array is much more efficient that opening a text file > and reading values from it. The main benefit of the text file, it is easier > to maintain if values will be added, removed or changed on a regular basis. > > The difficulty with either select case or an array is that if values must be > added, removed or changed the program must be updated and recompiled. > > Thus one must analyze will the values change often and if so who will > maintain it, a programmer or end user? If they won't change often (or maybe > even if they will) is program efficiency more important than ease of > administration? > > My 2 pennies worth. > > -- > > Bill Palmer > Financial Systems Analyst > Mid-Columbia Medical Center > The Dalles, OR 97058 > 541-296-7417 > > > > > > CONFIDENTIALITY NOTICE: This e-mail message (including attachments) is > covered by the Electronic Communications Privacy Act, 18 U.S.C. > 2510-2521, and is intended only for the person or entity to which it is > addressed and may contain confidential and/or privileged material. > Any unauthorized review, use, disclosure, dissemination, copying, forwarding > or distribution is prohibited. If you are not the intended recipient, please > contact the sender by reply e-mail and destroy all copies of the original > message. If you are the intended recipient but do not wish to receive > communication through this medium, please advise the sender immediately. > > --- > To post a message to this list, send mail to: [email protected] > > You are currently subscribed as: [email protected] > > Unsubscribe in the customer center on our website: > http://www.bostonworkstation.com/customer_center/virtual_user_group_talk.aspx > > > CONFIDENTIALITY NOTICE: This e-mail communication and any attachments may > contain confidential and privileged information for the use of the designated > recipient(s) named above. If you are not the intended recipient, you are > hereby notified that you have received this communication in error and that > any review, disclosure, dissemination, distribution or copying of it or its > contents is prohibited. If you have received this communication in error, > please notify the sender at the electronic mail address noted above and > destroy all copies of this communication and any attachments. Thank you for > your cooperation. > > --- > To post a message to this list, send mail to: [email protected] > > You are currently subscribed as: [email protected] > > Unsubscribe in the customer center on our website: > http://www.bostonworkstation.com/customer_center/virtual_user_group_talk.aspx CONFIDENTIALITY NOTICE: This e-mail message (including attachments) is covered by the Electronic Communications Privacy Act, 18 U.S.C. 2510-2521, and is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any unauthorized review, use, disclosure, dissemination, copying, forwarding or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. If you are the intended recipient but do not wish to receive communication through this medium, please advise the sender immediately. --- To post a message to this list, send mail to: [email protected] You are currently subscribed as: [email protected] Unsubscribe in the customer center on our website: http://www.bostonworkstation.com/customer_center/virtual_user_group_talk.aspx
