Question by  saltersproducts (25)

How do you create a list from an array in excel vba?

I do not understand array variables and how they effect the creation of a list in excel VBA.


Answer by  peacock (36)

Excel is a worksheet containing rows and columns. Row name starts from 1,2,3 etc order and cells starts from A,B,C etc. We can create a list from a document or data base. we can enter the values to the corresponding cells and columns. Each cell has an address. That is related to row and column.


Answer by  gigo (1706)

The first step is to create a list like that: Dim arr() arr=Array("one", "two", "three") After that you can assign values: arr(2)=... cells("A1")


Answer by  Jalaine11 (2043)

The best way to learn how to do this is to go to the help section of your excel program. It should walk you through the process step by step. It often include pictures showing you what you should see on screen. Another option is to read your manual.


Answer by  murali680 (559)

The followings are the procedure to create a list. Dim arr() arr=Array("1", "2", "3") Values: arr(2)=... cells("A1") For further information we can use the manual or search the help option of our excel program.

You have 50 words left!