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
- how to generate a rondom number btween two ranges
- Change every second column to a negative number
- find the number of working days (monday to firday) between two give
- 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
- Average of numbers ; matrix
- How to take digits as input then print them as a number?
- gcd of given number
- number finder!
- sum and difference of 2 bcd numbers
- prime number problem
- perfect number
- assembly program that reads an integer number (from 0 to 9).
- an assembly program that reads an integer number from the keyboard and then displays its diviso
- Write a C program that shall perform sort 10 numbers using insertion sort and stack operation.
- prime number
- programming to display series of 24,99,224,399....upto 10 numbers