Load Excel Combobox when the excel is opened
I have Combo box in Excel and I have following VBA code. But now working when the excel is opened.
Sub worksheet_activate() mapping.clear mapping.Additem "File to Table" mapping.Additem "Table to File" End Sub
Now , tell me how to load the combobox automatically when the excel is opened.
It worked when I did like this. Do this in Worksheet macro.
Private Sub Workbook_Open() With Sheet1.mapping .AddItem "File to Table" .AddItem "Table to File" End With End Sub