cell application

[kevin_xsw]

I mean ,just like enclose form ,there are cell in top of form A column. when you click anyother cell in the form , the cell of top alway display cell's content related A ROW which you click !, Is it clear .if you have good idea , also can send it to my e_mail :kevin_xsw@yahoo.com.cn

[WinteE]

Hi Kevin,

You need a macro for this :

Private Sub Worksheet_Change(ByVal Target As Range)

    If Not Intersect(Target, Range("A7:A10")) Is Nothing Then
        Range("A4").Value = Target.Value
    End If

End Sub

Copy this code into the VBA worksheet-object.

What does the code do :

If the change you make is in range A7:A10 then the changed value will also be stored in cell A4.

Success,
Erik