Delete blanks from combo box form control

[CalButler]

Hey,

I'm trying to delete the blanks from a combobox drop down list - newbie to VBA so despite searching threads for solutions I'm unsure how to edit the code to suit my workbook.

Any help much appreciated.

Cal

 

[Upex]

How are you feeding the inputs to the combo box?

If fed from a range of cells, then does that range contain blanks? If so, change the range and they'll go. Likewise if you've typed them in directly I guess, but hard to see where the issue is without seeing how it's being set up, but sounds to me like the range of options has the blanks in it.