Hello...this should be simple but it's annoying me trying to figure it out. I created a userform with 2 comboboxes. How do I specify what the drop down for the combo box is? I want it to be a range of cells...also I want ComboBox1 to populate after they hit submit button to cell C2 and ComboBox2 to populate to E2. One last thing I want this to basically force the user to submit this info so I want the X button in the top right corner rid of or disabled and I want the userform to open when the workbook is open (that part I figured out how to do). Thanks!