Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calling VBA Function
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calling VBA Function
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |