LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 95
Default Automatically run a macro when a cell = FALSE

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
macro to automatically insert static time in a cell Bill Excel Worksheet Functions 7 June 10th 08 12:14 AM
run macro automatically when cell content is changed? Kathrine Excel Worksheet Functions 1 March 22nd 07 10:44 PM
Macro: automatically initiating upon cell click pmp613 Excel Discussion (Misc queries) 1 December 28th 06 09:46 AM
enter data in cell then run macro automatically R D S Excel Discussion (Misc queries) 2 January 25th 05 10:19 PM
Can I automatically start a macro if the contents of a particular cell change markshowell Excel Programming 1 March 2nd 04 07:29 PM


All times are GMT +1. The time now is 06:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"