Real Time Macro

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

Conditional formatting can check data on an other sheet. Just create a name
for that data (Insert>Name>Define Name...), or use INDIRECT, such

=B2=INDIRECT("Sheet2!A1")

BTW, do you have Excel 97?

--
HTH

Bob Phillips

"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
>

Conditional formatting can use data from a separate sheet if you use a
defined name (insert=>Name=>define) and an intermediary to reference that
offsheet data.

--
Regards,
Tom Ogilvy


"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
>

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

--
Regards,
Tom Ogilvy

"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
>

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
>