the information in formula bar? 1

[horoscope]

A B C D E
1 2 3 4 10 (=SUM(A11))
the upper it is a worksheet. in E1 is result of SUM(A11).
in the formular bar of E1 ,i can see "(=SUM(A11)".
my question is how can i get it in vb.
in below code e2 is just the result of function. what i need the formular expression , how can i get it.
Private Sub Workbook_Open()
Dim e2 As String
e2 = Application.Sheets("Sheet1").Cells(1, 5)
MsgBox e2
End Sub

 

[Hypetia]

Very simple. Just look into the Formula property of the Range object.
___
[tt]
Private Sub Workbook_Open()
Dim e2 As String
e2 = Application.Sheets("Sheet1").Cells(1, 5)[tt].Formula[/tt]
MsgBox e2
End Sub[/tt]