View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default Multiply The Contents Of Two TextBoxes With The Result To Appear In A Third TextBox

Try

TextBox3.Text = Cstr(CDbl(TextBox1.Text) * Cdbl(TextBox2.Text))

The CStr is just to be sure.

--

HTH

RP

"Minitman" wrote in message
...
Greetings,

I need to multiply the contents of TextBox1 with the contents of
TextBox2 and have the result show up in TextBox3. These three
TextBoxes are all on UserForm1.

I can't seem to get the syntax right. When I try to run any code It
kicks me into the debugger. Here is the code:

Private Sub TextBox1_Change()

SaveButton.Enabled = True
TextBox3.Value = (TextBox1.Value * TextBox2.Value) <<<<

End Sub

I also have it in TextBox2_Change()

The entry in TextBox1 is hours in decimal format and the entry in
TextBox2 is the rate in Dollars. All three TextBoxes have formatting
in an Exit event.

Any one see where I messed up?

TIA

-Minitman