i added a combobox in excel and now trying to add item to that combobox from the macro but i can't. here is what i got. using excel 2007 to write the macro but i will need to save it for 97-2003 office. also do i need to add any references? thank you
Private Sub Workbook_Open()
combobox1.AddItem "Credit Card"