execute external program when cell reaches certain value

[Brendan DJ Murphy]

Hi,

As the subject-line says, Is there an easy way to make Excel execute
another program triggered by a cell meeting a certain criteria?

Thanks

Brendan

[aileen_magee]

Hello,
You could use something like:
While Range("B11") = "25" Then
Shell ("C:\WINDOWS\system32\notepad.exe"), vbMaximizedFocus
Wend
While Range("B11")<>25 then
.....
Wend

[Andrew-R]

You need to put some code tags in your reply, Aileen.

Also, I'd be wary of putting a shell command inside a while loop, unless closing down 7 gazillion Notepad windows is your idea of a good afternoon

Brendan - the easiest way to do it would be to put some code in the worksheet change event. If you give us a bit more detail about what you're trying to do people will be able to give you some more specific advice.