Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Put the code below in the worksheet code module. Do this by right-clicking
on the sheet tab, and select view code. Then paste this: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$A$3" And Target.Value = 10 Then Beep End Sub "João" wrote: Hi! I'm trying to 'ask' Excel to Beep evrytime a condition turns TRUE. For example, every time cell A3 equals 10, beep. I did a Sub Noise () in VBA so I could call that Sub in that If statement but how can I do it? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calling a function in my SQL-DB from VBA | Excel Discussion (Misc queries) | |||
Calling DLL function | Excel Programming | |||
Help with calling a function | Excel Programming | |||
calling a function | Excel Programming | |||
Calling Function | Excel Programming |