How to input a vba calculated value

**mjseibert** · 07-26-2012, 03:47 PM

I am new to VBA so this will probably be a very simple question. I have 3 columns that will have data entered into them (an operator will input 3 lengths, one into each column). This data will change frequently. I have a calculation that will be run each time new data is entered. However, I only want the calculation to run when a command button is pushed and want the answer to be inserted into certain cell. The reason behind this is we want to keep the previous calculation from being accidentally erased. The idea is that you can change the data but a new answer will only be displayed if the command button (labeled CALCULATE) is clicked.

Any help for a newbie would be great. I don't have to use VBA much, and when I do, it's for simple items like this. Any help would be great. Thanks,

**tlafferty** · 07-26-2012, 03:57 PM

This will turn calculation in the book off and then only calc when the button is clicked. It will take a bit more doing to decide where to place results, so I need a bit more information for that part.

Please Login or Register  to view this content.

**mjseibert** · 07-26-2012, 04:14 PM

Thanks for the reply. Here is more infomation. I am inputing my 3 data points in A4, B4, and C4. The solution will be updated in merged cell. The cells being merged are A20:D22. Let me know what other info you need.

**tlafferty** · 07-27-2012, 12:10 PM

Does the merged range A20:D22 contain a formula such as =SUM(A4,B4,C4) or =A4*B4*C4 or will it be the result of some calculation based on the 3 lenghts put in and you want the macro to handle the results. Is this like a quiz/math drill and you have students who have to make guesses at the answer?