Sound when a value is entered.
 

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.

Sound when a value is 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


"Loren" wrote:

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.

Sound when a value is entered.
 

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.
"FSt1" wrote in message
...
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


"Loren" wrote:

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.