Sound when a value is entered.

  • Thread starter Thread starter Loren
  • Start date Start date
L

Loren

How do I get Excel to make a sound when a value is entered into a cell? I'm
using a digital caliper to enter data into Excel via a USB port. I don't
want to have to look at the screen each time I enter a value to verify that
the information got entered.
 
hi
you can use beep on the worksheet change event.
Private Sub Worksheet_Change(ByVal Target As Range)
Beep
End Sub

but some pcs have a pretty wimpy beep. mine is more like a thump.

regards
FSt1
 
That's a good one. I used to use 'Beep' years ago but I'd forgotten about it
after years of working on a company network which had no sound in the main.
Thanks for the reminder,
Regards,
Alan.
 
Back
Top