Search: | |||||

| ||||

Home » Forum » MS Office | RSS Feeds |

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.

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.

Related Topics:

- addition of N numbers in NASM
- Addition of two 4-element word arrays in decimal
- find the number of working days (monday to firday) between two give
- how to generate a rondom number btween two ranges
- Change every second column to a negative number
- Whether the number is the power of two or not.
- how to wite the java projaram ading to numbes wothot addition(+)
- Removal & subsequent addition of GUI components on Applet
- Addition at the same column
- Converting a "Stringed" Number to a Number
- Converting a "Stringed" Number to a Number
- Simple addition and subtraction...
- type casting /converting seconds to a days hours minutes seconds
- program to count the number of occurrences of any two vowels in succession in a line of
- Getting the time for the Number of records retrived
- Datagrid Display - right align numbers
- Math function to determine if a number is an int
- Number fields in Excel being considered NULL (empty)
- Jbuilder Serial number
- generating random numbers
- Number Format
- Pocket PC 2002 PDA to dail a phone number
- julian day number
- Formating the Number
- get the number of JList which is created by array