Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Addition of two numbers

  Asked By: Jimmy    Date: Dec 13    Category: MS Office    Views: 1676
  

I m new to VBA in excel

i want to create a simple program , pls. help me as i don't know how to

Program Description

1. User inputs 'a' and 'b' in 'textbox' of form
2. clicks 'addition' button on form
3. values of 'a' & 'b' will be passed in the cells of excel
4. excel calculates the sum 'a+b' in cell "c"
5. Now value of 'c' will be reflected on the form

will u pls help me.

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Tyrell Thompson     Answered On: Dec 13

I am not sure what help  you need.

In essence you need to:
Put the formula in the third cell  on your spreadsheet to add the first two
cells
Open the VB editor
Insert a userform
Place three text boxes on the form
Place a button  on the form
On the click action of the button
-set the value of the first cell to the value of the Textbox a
-Set the value of the second cell to the value of Textbox b
-set the value of Textbox c to the value of the third cell

Please come back to the list if you have any specific problems with this.
Tell us what you have done, show us your code, and tell us what the problem
is.

 
Didn't find what you were looking for? Find more on Addition of two numbers Or get search suggestion and latest updates.




Tagged: