Hi there,
I try to resume my scenario.

I have a cascading combo box to control with VBA.
I did it in filtering the values with the 1st combo and show in 2nd only the filtered items.
Whenever I choose a category from the 1st combo, my 2nd combo list updates, which is fine.
The problem arises when I already selected a category and I want to change it.

My userform displays data (picture, volume, price, etc) in textboxes (in the same userform) when triggered by the changes made in the 2nd combo via match and vlookup VBA formulas.

After the user change again the 1stcombo I clear the 2nd combo to avoid old data would remain at the top of my 2nd combo list..as a result, the code which is 'listening' for changes made in the 2nd combo list shows me a 1004 error, since there's nothing to match.

I created a simple delay in 2ndCombo_change() sub which is activated when 2ndCombo value is null and it works good.
Here's the code:
Please Login or Register  to view this content.
AIM:
Now I want to show a msgBox when a selected choice in 1stCombo reflects in null value for 2ndCombo AFTER the above IF statement.
Some categories of the 1st combo don't have any sub-element yet and I want to tell the user so.

MY TRY:
I changed the 2stCombo_change() sub like this
NOTE: my 2stCombo is named sceltaArredi
Please Login or Register  to view this content.
MORAL:
I get an error at the Else: If row.
If I remove the If condition after that Else debug asks me for it, when I write Else If and reload the userform my code changes like above and still gives me error.

Any hint?

thanks in advance
P.