Solver Macro triggered if condtion reached

Hi all still struggling with VBA. I would like to run/trigger the following code (see below) if cell D2 which is a countdown clock is 00:01:05. I have played around with event change etc without success. I do however have a problem with the original code as i get a compile error sub/function not defined with the code below.

Please Login or Register  to view this content.

Sorry if this is a double post (i dont think so) however after originally posting it i could not find it under my posts. Any help greatly appreciated

Thankyou
Dan

I resolved the compile problem, though still looking for code that will trigger macro for the above code. I tried the code below however when i run it it just brings up my list of macros and nothing happens. Any ideas. If the above is in any way vague please let me know.

Please Login or Register  to view this content.

Regards
Dan

When i run this (see below) i am getting a runtime error 1004 method range of object... failed. Any ideas

Please Login or Register  to view this content.

Thanks
Dan

thanks for the reply Dgagnon. I tried your suggestion though it is saying expected list or seperator...

Regards
Dan

Thanks for the reply
Tried as you suggested now i when i run macro within visual basic window it brings up a list of all my stored macros and does nothing
else. The Sub Solver part of the code works well if i manually run it just can't seem to get it to trigger automatically when aforementioned condition is reached. The result of just showing a list of stored macros (of which Mont (the new name) is a part) may be a clue to what i am doing wrong. Any ideas much appreciated.

Thanks again