Filling Dropdow from a range skipping nulls

[reecetn]

Hello

I am wondering if there is a way to fill a excel dropdown with values from a range on the form load without including any nulls that might be in that range.

Thanks
Reece

[6StringJazzer]

Needs code. Blank out the ListFillRange property of the box and add this code to Sheet1:

Please Login or Register  to view this content.

When the worksheet is activated, this will populate the dropdown with any constant values in column H.

[reecetn]

Thank you very much for your help

Reece