You may try this macro in the SelectionChange event of the worksheet:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
On Error Resume Next
If Target.Column = 1 Then
Range("B1").Value = Target.Offset(0, 2).Value
End If
End Sub

Hope this helps,
Miguel.

"MIchel Khennafi" wrote:

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