Nope, just a cell. It's an order form and I'm already using
Private Sub Worksheet_Change(ByVal Target As Range).
Case structure based  on the Target.Row, so I know what cells have what ranges
and critria.
All inputs cells are in the same column.

I will look over your code but at first glance it looks good.