User form combo box

Hi,

Please can someone help, i'm trying to create a combobox with the list "buy and sell" but keep getting the error message "run-time error 70: permission denied".

Private Sub ComboBox2_Change()
ComboBox2.AddItem "Buy", "Sell"

End Sub

If your combobox is inserted in a worksheet, try this macro that you will place in specific sheet in VBE

Private Sub Worksheet_Activate()
ComboBox1.AddItem "Buy"
ComboBox1.AddItem "Sell"
End Sub

It will trigger every time the sheet is activated. It could also be placed in ThisWorkbook section and be triggered by the workbook openning (Private Sub Workbook_Open())

If you are using your combobox in a userform, you should put this code in "Private Sub UserForm_Initialize()"

If your combobox is inserted in a worksheet, try this macro that you will place in specific sheet in VBE

Private Sub Worksheet_Activate()
ComboBox1.AddItem "Buy"
ComboBox1.AddItem "Sell"
End Sub

It will trigger every time the sheet is activated. It could also be placed in ThisWorkbook section and be triggered by the workbook openning (Private Sub Workbook_Open())

If you are using your combobox in a userform, you should put this code in "Private Sub UserForm_Initialize()"

Try this.

Private Sub UserForm_Initialize()
    Me.ComboBox2.List = Array("Buy", "Sell"
End Sub