Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Rob,
Application.Wait won't give you the precision you need to space out your beeps. You could use the Sleep API function: Private Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long) Sub MultiBeep(NumBeeps As Integer) Dim Counter As Integer For Counter = 1 To NumBeeps Interaction.Beep Sleep 200 Next Counter End Sub -- Regards, Jake Marx MS MVP - Excel www.longhead.com [please keep replies in the newsgroup - email address unmonitored] Rob wrote: This only beeps once. I think I need to add in a line like application.wait or something, but that didn't work, so does anyone know what I should do? Thanks. Have a good Weekend. Rob Sub MultiBeep(NumBeeps) Dim Counter For Counter = 1 To NumBeeps Beep Next End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Beep on greater than zero | New Users to Excel | |||
BEEP | Excel Discussion (Misc queries) | |||
turn off beep | Excel Discussion (Misc queries) | |||
I want to *beep* *beep*!!!! | Excel Programming | |||
Displaying a Message and a Beep | Excel Programming |