New Product Form with Drop Down Lists for Category and Location

[75Rupert]

Hello,

How can the form to Add New Product (Report sheet green shape on right "+ Product") have the fields for Category and Location be drop down lists from the tables on the Products sheet?

Thank you very much for your help

[75Rupert]

I figured it out. They need to be combo boxes and the row source for each are the table names. Also the code lines need to be combo box values [.Cells(rw, "D") = ComboBox1.Value]