Thread: Arrays
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
JMB
 
Posts: n/a
Default Arrays

Actually, your range object is an array. You can access individual cells by

Selection(3,2).Value

You should be able to just drop your selection object into the listbox.

Sub test()
UserForm1.ListBox1.Clear
UserForm1.ListBox1.List = Selection.Value
UserForm1.Show
End Sub

"Brendan Vassallo" wrote:

I am doing a mcaro where i want to take a slected range of cells and convert
it to an array so i can add it to a list box on a user form. The problem is
once I get my range of cells selected I have no idea on how to convert it to
an array and make a variable such as intAdd equal to that array so I can add
it to the list bow. Can anyone help????
--
Brendan Vassallo