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 check data on an other sheet. Just create a name
for that data (InsertNameDefine Name...), or use INDIRECT, such

=B2=INDIRECT("Sheet2!A1")

BTW, do you have Excel 97?

--
HTH

Bob Phillips

"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

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

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

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