If you insist on a macro see Chip Pearson's page on events
http://www.cpearson.com/excel/events.htm

--
Regards,
Tom Ogilvy

"McManCSU" wrote in
message ...

This is probably a stupid question, but what do you have to do
differently to have a macro that runs at real time? What I need is to
change data fields depending on what a drop down menu has on it. I
tried cond'l formatting, but it doesnt let me grab data from a
different sheet... So now I need to make it real time..

Thanks


--
McManCSU
------------------------------------------------------------------------
McManCSU's Profile:
http://www.excelforum.com/member.php...o&userid=24379
View this thread: http://www.excelforum.com/showthread...hreadid=392555