Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm trying to make what I thought was a simple metronome.
I have a userform with a scroll bar and a toggle button The toggle buttonn is for the start stop. the scroll bar is for the time value in between taps. right now it is working when I start it but then I cannot click on the toggle button again to get it to stop, or click on the scroll bar to change the tempo value. How can I run a loop and stiil be able to click on a button on the user form? Here is my code... Private Sub ToggleButton1_Click() Do While ToggleButton1.Value = True Sleep ScrollBar1.Value Application.Run "tap" ' Plays C:\WINDOWS\Media\start.Wav Loop End Sub Thanks Kevin |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
returning back to loop check condition without completing the loop | Excel Programming | |||
Loop to Filter, Name Sheets. If Blank, Exit Loop | Excel Programming | |||
Naming Worksheets - Loop within a loop issue | Excel Programming | |||
(Complex) Loop within loop to create worksheets | Excel Programming | |||
Advancing outer Loop Based on criteria of inner loop | Excel Programming |