Cell Format

[Vladq07]

Hello,

I am writting a macro, but I do not know how to do the following:

I need to be able to see a formula in the "fx" section on top of the worksheet, but at the same time I need to be able to see the total of the formula in the cell. It is already working, but I have a small problem. I need to double click on the formula and then hit "Enter" so it will show the result.

For example: in the cell I have the following " = 8+8+8", in order for me to see the total "24" I have to double click on the cell and hit "Enter", so it will show "24" on the cell, but it will keep showing the formula "=8+8+8" in the "fx" cell on top of the worksheet.

I want to write a macro in order to get rid of the manual process of the double click and the enter.

Thanks,
Vlad

[lucas]

moved to appropriate forum. Vlad, you will come closer to getting help with Excel here than in the announcments forum.

[lucas]

Vlad, please don't continue to post the same question in multiple threads.

[georgiboy]

Can you post a workbook with an example of this?

[Vladq07]

Thanks, I was new and I did not know where to post my questions. However, it looks like it is already where it is supposed to be. Let me know if I still need to remove it from the "announcments forum"

[lucas]

Vlad, I moved it so you don't have do anything except provide georgiboy with a simple example workbook so he can see what you are trying to do.

hit post reply at the bottom left of the last post....post your messange and then scroll down and look for the button that says "manage attachments"