ActiveX Combobox in worksheet when populating the list based on another Combobox get error

When the selection chosen in Combobox3 is changed the following code runs. The issue occurs at the following lines

Please Login or Register  to view this content.

The actual error is Run-time error '381': Invalid property array index

any help identifying the issue would be greatly appreciated.

Looking at the property window for Combox1 the ListFillRange is empty, so it can't be this that is causing the error.

Please Login or Register  to view this content.

Your range is wrong. It should be:

Please Login or Register  to view this content.

Glad to help. Thanks for the rep.