Cell Active as argument..... IS IT IMPOSSIBLE?

[WalterNavarroG]

Hello my friends

I want to write a formula with info of cell active as argument.

Let's say. I want to display in cell A1 different text according to th
position of the cell active. If I change the cell active, then the tex
in A1 changes.

Can anybody help me?

:confused

 

[Frank Kabel]

Hi
not possible with formulas alone. This would require using
an event procedure (e.g. the selection_change event). See:
http://cpearson.com/excel/events.htm