Vladq07
01-08-2009, 08:24 AM
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
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