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" <McManCSU.1t74eh_1123085423.666@excelforum-nospam.com> wrote in
message news:McManCSU.1t74eh_1123085423.666@excelforum-nospam.com...
>
> 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
>