I have a cbo in sheet 1 called cboSelect. I would like to write code in a module that will fire when the file is opened, but dont know how i can run code in a module that will run from the workbook open even and fill a combo box in sheet 1
(thisworkbook)
Private Sub Workbook_Open()
FillCbo 'This will be in module1 of the current worksheet
End Sub
(module1)
Sub FillCbo()
Dim i As Integer
For i = 2 To Sheets("SYMBOL TABLE").UsedRange.Rows.Count
cboSelect.AddItem (Sheets("SYMBOL TABLE").Range("A" & i).Value)
Next
End Sub