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

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)

"Gordon" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>