Hello. I have a spreadsheet where a order number will go in col A. Once I hit tab a shape (barcode) appears in col B (there is a formula in the cell in col B tied to vba coding to create shape. Sometimes the wrong order number is entered (typo). Is there a way w vba to delete the shape in col B when the order number is deleted in column A.
Placement example:
Order number in A4 and shape in B4
The formula in col B doesn't need to be deleted, just the shape.
Any help would be exceedingly appreciated. Thank you!
Placement example:
Order number in A4 and shape in B4
The formula in col B doesn't need to be deleted, just the shape.
Any help would be exceedingly appreciated. Thank you!