Sounds like you want a worksheet change event.
You can put a Data Validation list into a cell and than when you change the
selection in the list - the event will fire.

Event macros go in the worksheet module. Say the Data Validation is in cell
A1

Private Sub Worksheet_Change(ByVal Target As Range)
If target.address = $A$1 then
msgbox "Do your stuff"
end if
End Sub

--
steveB

Remove "AYN" from email to respond
"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