You are using RowSource property of combobox to list the values. So don't need to loop and add the items. Otherwise just remove the namedrange from the rowsource property of respective comboboxes. Also check your sheet names.
You are using RowSource property of combobox to list the values. So don't need to loop and add the items. Otherwise just remove the namedrange from the rowsource property of respective comboboxes. Also check your sheet names.
Cheers !
Excel Range to BBCode Table
Use Social Networking Tools If You Like the Answers !
Message to Cross Posters
@ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)
Posting Permissions
Reply With Quote
Bookmarks