Just a little bit of function help

[Stuie]

basically what im tryin to do is with two label captions is to add them together and display the answer in one of the labels...

i have managed to do this subtracting the two captions but not adding them example...

to subtract them i did this:

label1 caption is 30
label2 caption is 10

(Dont think i had to put .caption on the sum part)
label1.caption = label1.caption - label2.caption

and from that i get 20 as the caption

now if i do the same sum but with + instead of - i get the answer 3010
how do ya get round that...

oh and how do u format a label caption to currancy so it always shows a (£)sign that wud be really helpful to know

any help wud be very welcome

[antoka05]

Try so:
val(label1.caption) + val(label2.caption)

The val function convert from string to value

[Myles]

Please Login or Register  to view this content.

x = Application.Sum(Label1.Caption, Label2.Caption)
MsgBox x

[Stuie]

cool that brilliant thanx chaps