Hi,

In the code attached to the button click event simply use

Range("A1")=Range("A1")+1
where A1 is the cell containing the Units. However is this the best way of proceeding? Why not just enter the unit quantity directly?

HTH