ExcelBanter - View Single Post

Gary''s Student

See:

http://www.mvps.org/dmcritchie/excel....htm#blueboxWs
--
Gary''s Student

"Quaisne" wrote:

I have been asked the following by sa friend. I do not know the answer

"does anyone know how to write what i think is called an "event macro"

let's say that i have a simple spreadsheet that adds up a column of
numbers... i want to write a macro that will automatically run another
macro (say one that colours in a certain cell a particular colour)
whenever the subtotal goes above a certain level.

note that i know how to use conditional formatting etc, the above
example is very much a simplified version of what i'm trying to do -
the second macro in question is actually a goalseek in another part of
the workbook.

thanks! "

Can anyone help?

--
Quaisne
------------------------------------------------------------------------
Quaisne's Profile: http://www.excelforum.com/member.php...o&userid=28052
View this thread: http://www.excelforum.com/showthread...hreadid=487572