Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
MouseDown()-MouseUp()
In one of my sheets I have button, starting a macro wih "MouseDown()". This macro starts a simple loop. No problem. But what I want is that when I release the mouse button, the macto stops before ending the loop. Now it goes till the end. Now it's something like this: Sub CommandButton2_MouseDown() For i = 1 To 20 Sheets("Plan1").Range("a1").Value = Sheets("Plan1").Range("a1").Value + 1 For j = 1 To 2000 Application.Calculate Next j Next i End Sub The "j-loop" (For j = 1 To 1000) is only there to slow down the execution. Thanks all. Have a nice sunday. Stoffer Krol -- skrol ------------------------------------------------------------------------ skrol's Profile: http://www.excelforum.com/member.php...o&userid=27126 View this thread: http://www.excelforum.com/showthread...hreadid=476586 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Chart MouseUp Event Feedback | Charts and Charting in Excel | |||
mouseup | Charts and Charting in Excel | |||
Mousedown / Charting | Excel Programming | |||
get reference to cell from mousedown event | Excel Programming | |||
Converting MouseDown Coordinates to Chart Point Coordinates | Excel Programming |