Macro to ask for two figures and subtract the first figure from the second and input that

[DannyJ]

Hi,

I amlooking for a macro that opens an input box asking for 2 figures. These figures aren't to be shown anywhere in the worksheet they are just to subtract the first from the second and then input the result.

I am guessing the best way to do it is an input box but not sure if that can do it as I wish?

Also, I would need the macro to start up on the click on the cell not as a command button as there are other cells that autopopulate in the workbook. This would be done in A2 and then A3 etc.

EDIT: There could be more than 1 sum too. So it could be 2 results of sums to be added together after.


Thanks in advance

Daniel

[Mumps1]

Hi Daniel. Copy and paste this macro into the worksheet code module. Do the following: right click the tab for your sheet and click 'View Code'. Paste the macro into the empty code window that opens up. Close the code window to return to your sheet. Click any cell in Column A. You will be prompted to enter the two numbers and the result will be placed in column B.

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Try this too see if you can use it. It operates on Sheet1 by Double-Clicking in A2.

[DannyJ]

Thank you John and Mumps. I have test Mumps' code and that does the job. Would it be possible to maek this occur for more than 1 set of numbers so for example "Number 2 - Number 1" and "Number 4 - Number 3" and then add the 2 figures together?

Would it be possible to make z input into column A John and the same with regards to multiple sums?

Thanks for the quick replies.

Danny

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[DannyJ]

Thank you John,

That now works for a single sum. Is it possible to make it so there is an option for 2 sums to be done and add the results together?

Thanks,

Danny

[JOHN H. DAVIS]

Does this help?

Please Login or Register  to view this content.

Changed click cell to A1.

[DannyJ]

That is almost there John. Sorry, I am not being clear. It would be input two values, call them x and y and then y - x = z.

Then the second time it would be a and b. b - a = c

Then c+z is the value input into column a. All as one vba code and just one figure output at the end.

Thanks for the replies .

[JOHN H. DAVIS]

Confusing too me. Try one of these:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[jindon]

Try

Please Login or Register  to view this content.

[DannyJ]

Thank you jindon and John they both work. (John the top one worked for me ) really appreciated the help guys

[JOHN H. DAVIS]

You're welcome. Glad to help out and thanks for the feedback. Please mark this thread as SOLVED.