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.

Answers


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

Need Your Help

Web Servers and REST Methods

http rest browser webserver

Most web browsers support only HTTP methods like GET and POST and do not support PUT and DELETE.

ORA-01036: illegal variable name/number while updating gridview

c# asp.net oracle gridview

I want to update a cell of the row in gridview. But I am getting error as