Array & ComboBox

[Gordon]

ComboBox Initalze will not reconize Public MyArray()

Declaration: Public MyArray() As String
( do not know how many entries into array)

Sub Test()
ReDim Perserve MyArray(1)
My Array(1) = ActiveCell

XXX.Show (ComboBox)
Initialze will not reconize MyArray

2nd Question
How do you load List in ComboBox from an Array?

Thanks again
GJ

 

[Bob Phillips]

MyArray = ActiveCell
ComboBox1.Value = MyArray

and

MyArray = Range("H10:H12")
ComboBox1.List = MyArray



--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)