ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   UserForm and TextBox Arithmetic (https://www.excelbanter.com/excel-programming/328855-userform-textbox-arithmetic.html)

t_hayata

UserForm and TextBox Arithmetic
 
I have 3 TextBox on an UserForm: TextBoxTotal, TextBoxA, and TextBoxB
On the UserForm I have the associated VBA code:
TextBoxTotal.Vallue = TextBoxA.Value + TextBoxB.Value.
I cannot get the arithmetic sum. However, I get the logical union
How do I get the arithmetic sum using operations on TextBox's?
--
Tomo

Robin Hammond[_2_]

UserForm and TextBox Arithmetic
 
Tomo,

Something like

TextBoxTotal.Text = cStr(cdbl(TextBoxA.Text)+cdbl(TextBoxB.Text))

Robin Hammond
www.enhanceddatasystems.com

"t_hayata" wrote in message
...
I have 3 TextBox on an UserForm: TextBoxTotal, TextBoxA, and TextBoxB
On the UserForm I have the associated VBA code:
TextBoxTotal.Vallue = TextBoxA.Value + TextBoxB.Value.
I cannot get the arithmetic sum. However, I get the logical union
How do I get the arithmetic sum using operations on TextBox's?
--
Tomo





All times are GMT +1. The time now is 05:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com