VBA Question-and-Answer Type Macro (Mathematical)

[danb3345]

Hello,

I am looking to write a code in VBA Excel such that:

1. A series of questions on a spreadsheet are asked, where numerical answers are filled-in in the adjecent cell. Eg. How many balloons? 6

2. A button below the list of questions reads ''Calculate'' and runs a specified mathematical calculation based on the numerical answers above when clicked. The answer is displayed either in a cell on the spreadsheet or in a pop-up window.

The reason I want a macro for this instead of just simply formulating the equation within the spreadsheet is that I do not want the ''answer'' to apparently change as the values are added in. I want the answer only to appear upon clicking of the mouse.

If anyone knows a link to a good tutorial or anything in general that may assist me with this it would be appreciated.

Thank you in advance and I apologize for the most certain reduncy of the nature of my question.

Dan

 

[danb3345]

Friendly reminder. Thank you.

 

[kpark91]

Well..
You can google "VBA tutorials" as there are some good websites you can just find.
For this question, I think you must use something called
"Click" Event.

It means whenever an object is clicked, the code inside the event will be executed.
So, if a button is called cmdBtn

Private Sub cmdBtn_Click()
 'Your code
End Sub

should do the trick.