Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Stopping a Looping Macro
Can someone please help this complete newbie where macros & VBA are
concerned? I've obtained a macro from the web which does exactly what I was looking for but I now need to tweak it a bit. [for info: it generates random numbers in certain cells] a) I would like it to *loop* until certain criteria are met e.g. "A1=7" _and_ "B1 20" b) I would also like to be able to stop it manually [e.g. by pressing a certain key] to prevent it going into a permanent loop. BTW I'm using Excel 2002 Any help appreciated TIA Tony |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Stopping a Looping Macro
you could use a do until loop like this dim rg as range Do your macro Set rg = (insert the cell to check here) Loop Until rg.Value = somethin -- dropste ----------------------------------------------------------------------- dropster's Profile: http://www.excelforum.com/member.php...fo&userid=1339 View this thread: http://www.excelforum.com/showthread.php?threadid=27313 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Stopping a Looping Macro
hi,
To stop a macro use Ctrl+Break. but for the loop, maybe posting your code would help. regards Frank -----Original Message----- Can someone please help this complete newbie where macros & VBA are concerned? I've obtained a macro from the web which does exactly what I was looking for but I now need to tweak it a bit. [for info: it generates random numbers in certain cells] a) I would like it to *loop* until certain criteria are met e.g. "A1=7" _and_ "B1 20" b) I would also like to be able to stop it manually [e.g. by pressing a certain key] to prevent it going into a permanent loop. BTW I'm using Excel 2002 Any help appreciated TIA Tony . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
looping and stopping cont | Excel Discussion (Misc queries) | |||
looping and stopping when a condition is met - test | Excel Discussion (Misc queries) | |||
stopping code from looping | Excel Worksheet Functions | |||
stopping macro | Excel Programming | |||
My Macro keeps stopping?? | Excel Programming |