View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Robin Hammond[_2_] Robin Hammond[_2_] is offline
external usenet poster
 
Posts: 575
Default 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