Userform combo box with dropdown and excess blanks

Hi, I am really new to creating user forms but I'm trying to learn via forums and YouTube tutorials.
I have made a form and it has combo boxes. The dropdown is from a table where the biggest list in a column consists of 90 rows. My first dropdown may be a column with only 6 items that I want users to choose from but shows lots of blanks after my initial options. Is there a way to get the drop down to only populate the choices in the column and not populate the excessive blanks?
I have searched for an answer but all of the results relate to data validation lists and don't help my problem.
The 'Other' option should be the last selectable option but as you can see the blanks go on for a long time.

Screenshot 2022-05-25 120540.png

I found this code online... the idea is to create an array from a range & remove the blanks from the array. I've used/written code like this, and it works perfectly well.

Please Login or Register  to view this content.

Thank you for this. Problem solved

Great! If I helped you out, please consider adding rep