Urgent: Using macro in MS Excel!

[sl888]

Hi there,
Does anybody know how to do following in Microsoft Excel?

1. When select one/some records in one excel area, trigger a macro to display something in the another excel area?

2. When select one filter selection, then trigger a macro to do something as above?

Appreciate your prompt reply on this!! And please explain it in a bit detail as I'm new to use this kind of MS stuff...

[Vibhor Kumar Agarwal]

I don't think there is any macro which can fire on selection of certain records and just giving a query.

May be if you tell what you want, somebody may come up with something interesting.

[Tom Leavitt]

chusl:
You might want to peruse sites such as:
http://www.google.com/search?sourceid=navclient&ie=UTF-8&rls=GGLG,GGLG:2005-47,GGLG:en&q=macro+in+MS+Excel
OR:
http://www.exceltip.com/se/macros.html
Let us know.
Tom