Hillsy7,

I would recommend instead of the second userform, make each textbox be a combobox so users can select each item from a drop-down list. As far as inputting data into the active cell:

ActiveCell.Value = Me.ActiveControl.Value


Hope that helps,
~tigeravatar