Hi,
With my basic knowledge (if called that), I have a worksheet which uses:
VBA code for column A to enter the date and time automatically when data is entered in to column B.
Column B is read in from a barcode reader and font changes to red when a duplicate is read in.
Column C is blank and using conditional formatting fills the cell red when finds a duplicate.
However, I would like to:
Highlight the Duplicates the same as above but with a long keyboard beep. I don't think I can add the beep without VBA so could someone give me the full vba code to make the above happen?
Thanks in advance! this is by far the most useful excel site I found (as a novice)
With my basic knowledge (if called that), I have a worksheet which uses:
VBA code for column A to enter the date and time automatically when data is entered in to column B.
Column B is read in from a barcode reader and font changes to red when a duplicate is read in.
Column C is blank and using conditional formatting fills the cell red when finds a duplicate.
However, I would like to:
Highlight the Duplicates the same as above but with a long keyboard beep. I don't think I can add the beep without VBA so could someone give me the full vba code to make the above happen?
Thanks in advance! this is by far the most useful excel site I found (as a novice)