Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Once again,
if isError(workbooks("abcd.xls").sheets("abcd").range ("cell").value) = true then do ' your Macro loop end if that was not correct, because the do loop should be outside the if... otherwise it would be a neverending loop for sure... however, here it follows: do until isError(workbooks("abcd.xls").sheets("abcd").range ("cell").value) = false ' your Macro loop Maybe use if workbooks("abcd.xls").sheets("abcd").range ("cell").value = "false" instead if in the cell the word "false" is produced... use the code before if the cell shows an error... Obviously there are other issues like a neverending loop etc. but besides error-trapping, how could I get this to work? . Be aware of that problem... neverending loops are mean if users don't know how to interrupt them... Best Markus . |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
macro to automatically insert static time in a cell | Excel Worksheet Functions | |||
run macro automatically when cell content is changed? | Excel Worksheet Functions | |||
Macro: automatically initiating upon cell click | Excel Discussion (Misc queries) | |||
enter data in cell then run macro automatically | Excel Discussion (Misc queries) | |||
Can I automatically start a macro if the contents of a particular cell change | Excel Programming |