Array & ComboBox

  • Thread starter Thread starter Gordon
  • Start date Start date
G

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
 
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)
 
Back
Top