Multi Column Excel VBA Combo Box Not to show empty rows

[keromero]

Multi Column Excel VBA Combo Box Not to show empty rows...

Please see attached photo. Case 1 and Case 2.

I need 2 column drop down reference to cells "REFERENCE 01" & "REFERENCE 02"

Case 01 there are 10 rows but Case 02 only 5 rows.

So when case 2 I want to hide 5 empty listed rows at 2 Column COmbobox list.

Is there any way please?

 

[Fluff]

Duplicate to: Two Column VBA Drop Down only to show rows for non-blank cells.

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.