Need help on getting the detailed information of a cell.

[Ams_A]

Hello,

Can someone please help here.

I need to get the actual details (i.e. formula of a cell) instead of the result.

For e.g.

If I put in Cell A1 =45+55, then excel displays it as 100. I want the message box using VBA to give the output as 45+55 instead of the number 100.

Thanks in advance.

 

[venkat1926]

if you select the cell you can see the formla in the formrula bar above the data next to "fx"

 

[Firefly2012]

If I put in Cell A1 =45+55, then excel displays it as 100. I want the message box using VBA to give the output as 45+55 instead of the number 100.

Thanks in advance.

The Formula property of the Range object will give you this eg

MsgBox   Sheets("MySheet").Range("A1").Formula

 

[Ams_A]

The Formula property of the Range object will give you this eg

MsgBox   Sheets("MySheet").Range("A1").Formula

Hi Firefly2012,

That was the solution I was looking for.

Perfect. Thank You very much.

Sorry, I am new to this forum. Do I have to close to anything to mark this thread as solved or something. Also is there a rating or something that I can give to you on helping me on this. Kindly advise. Thanks.

 

[Firefly2012]

Sorry, I am new to this forum. Do I have to close to anything to mark this thread as solved or something. Also is there a rating or something that I can give to you on helping me on this. Kindly advise. Thanks.

You don't need to do anything (threads don't get marked as "SOLVED" here as they do at certain other forums). Your kind words are thanks enough

 

[Ams_A]

Many Thanks.