Basic VB help - trying to add some fields together

[bhp]

Does anyone now the VB code required to sum text fields.
In my example I have 5 seperate text fields that contain numbers and I need to create one "total" field which calculates the total of the values in the 5 fields?
Many - Thanks

 

[dwilson01]

This should work, you will have to change the addresses of the cells.

Cells(1,6) = Application.WorksheetFunction.Sum(Range("A1:A5"))

Dave

 

[bhp]

Forgive my very very basic knowledge, but could you give me an example of what a Application.WorksheetFunction.Sum would be?
Many Thanks

 

[dwilson01]

If you have numbers in column A rows 1 to 5

1
2
3
4
5

and you wrote the code:

Cells(1,6) = Application.WorksheetFunction.Sum(Range("A1:A5"))

then column A row 6 would have a value of 15.

 

[bhp]

No sorry I do understand that part, but where does the code indicate what text fields are being added together and waht cell is displaying the total?
Regards .......

 

[dwilson01]

Cell you want to display your total in = Application.WorksheetFunction.Sum (range you want to sum)

 

[bhp]

Many thanks will give this a go!