User form drop down box from list on another sheet

[Caveman1964]

Hi,
I want a simple drop down list in a vba userform.
The list is from sheet 2 a7:a20.
I have it where the form will activate but can't figure out the dropdown.
Also, if they dont click one I want a form to show that says missing info. I have that made. Its called missing info.
Summary
userform dropdown list from sheet 2 A7:A20
If nothing clicked, then show user form "Missing info"

Thanks ahead of time!

 

[Fluff]

Something like

Me.ComboBox1.List = Sheet2.Range("A7:A20").Value

In the Initialize event.

 

[Caveman1964]

Perfect! Thank you!

 

[Fluff]

You're welcome & thanks for the feedback