Use the Change event if it will be entered manually

see Chip Pearson's overview of events
http://www.cpearson.com/excel/events.htm

--
Regards,
Tom Ogilvy


"Jeanne Conroy" wrote:

Is there a way to create an "event based" macro in Excel? I need to have an
input box pop up whenever a cell value greater than 0 is entered.
Thanks!

--