Cell content of a cell based on the active Cell

[MIchel Khennafi]

Good afternoon,

I have a situation where the content of a cell is based on what the active
cell is. This is to display a Help message. I know i could use the Data >
Validation > Message but this is not a good use for what we are trying to
achieve.

If the Active cell is A1, then B1 = the content of a cell C1
If the Active cell is A2, then B1 = the content of a cell C2
If the Active cell is A3, then B1 = the content of a cell C3
.... and so on

Has anyone created such a macro (i suppose this is a worksheet macro)... Any
help woul dbe welcome

 

[Steve Schapel]

Michel,

The focus of this newsgroup is Macros in Access, the database product.
You may have a better chance of a good answer in an Excel-related newsgroup.