Is it possible to reference a cell using a variable in it name

dim var1 as integer
var1=3

listbox1.additem([c var1])

What I'm trying to do is place the contents of cell c3 into a listbox by using a variable in it's call out. This is not exactly what I'm trying to do but it the simplest way I can think to explain it clearly.

Thanks Mike

Hi Mike,
Have you tried using Cells(row index,col index)

So your code would look like:

dim var1 as integer
var1=3

listbox1.additem([cells(var1, 3)])

----------------

The number 3 is the number of the column.

Sarah :)

Make the variable type long. Row numbers may get well over the integer limit.