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".

Please Login or Register  to view this content.

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

Please Login or Register  to view this content.

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

Please Login or Register  to view this content.

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.

Please Login or Register  to view this content.