Sound when a value is entered.

[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.

 

[FSt1]

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

 

[Alan]

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.