VBA to delete shape in cell to the right of active cell when deleting contents of active cell

[slivesay]

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!

 

[Jeffrey Mahoney]

Two things.

Shapes aren't tied to a cell. They can't be referenced like that. Now, if your previous code were to name the shape based on the cell address, then you could delete the shape because you know the name.

I would consider getting a barcode font instead. Barcode fonts display the barcode right in the cell where you have the number. No shapes needed.