UserForm Adding TextBox Values

[James_Latimer]

Excel 2007
Hello, i was wondering if someone would be able to help me out please....

I have a userform with totals on it that have been formatted to Currency.

I have another textbox at the bottom for Grand Total. I need to add the values within each total box above but am finding it difficult to do so.

I used tb_Grand = o_Tot1 + o_Tot2 but this concatenates the two values together rather than adding them (ie £250.00£400.00 rather thatn £650.00)

I'm abviously being stupid but i have tried formatting allsorts but i cant seem to get the grand total to behave how i need it to.

Many thanks to anyone who can assist and i apologise in advance if this is a ridiculous question!!

 

[VoG]

Try

tb_Grand = Val(o_Tot1) + Val(o_Tot2)

 

[Norie]

James

You could use Val, eg Val(o_Tot1.Text), but that probably isn't going to work if you have formatted as currency.

You could remove the £, eg Val(Mid(o_Tot1.Text,2)) or not format as currency.