Hey GUYS,
Patrick gave me this the other night. Works great in the workbook he suplied
until i copy it and put it into mine. This part looks in column f finds the
the differant markets and fills the combo box in the form. The como box then
fills the list box with four differant columns. Take a look at this area
********** the error message reads compile error, user defined type not
defined. Any suggestions. Maybe other way to write it? THank you.
Private Sub LoadMarkets()
Dim markets As New Scripting.Dictionary **************
For index = 2 To source.Rows.Count
market = source.Cells(index, "F").Value
If Not markets.Exists(market) Then
markets.Add market, market
cmbMarket.AddItem market
End If
Next
End Sub
--
Though daily learning, I LOVE EXCEL!
Jennifer