Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
With the following code i keep getting this error. Can you help?
***Compile Error ***User_defined not type defined Private Sub LoadMares() Dim mares As New Scripting.Dictionary (THIS IS WHAT IS HIGHLIGHTED) Dim index As Long Dim Mare As String For index = 2 To Source.Rows.Count Mare = Source.Cells(index, 1) If Not mares.Exists(Mare) Then mares.Add Mare, Mare cmbMare.AddItem Mare End If Next End Sub -- Though daily learning, I LOVE EXCEL! Jennifer |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
SCRIPTING | Excel Programming | |||
Scripting Question | Setting up and Configuration of Excel | |||
Newbie VBE scripting question | Excel Programming | |||
VBA - running scripting dictionary (error!) | Excel Programming | |||
VBA question - Set reference to run Scripting.Dictionary | Excel Programming |