Multiply The Contents Of Two TextBoxes With The Result To Appear In A Third TextBox
 

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

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

Multiply The Contents Of Two TextBoxes With The Result To Appear In A Third TextBox - Solved
 

Hey Bob,

That worked really well.

Thank you.

-Minitman



On Sun, 24 Oct 2004 00:17:53 +0100, "Bob Phillips"
wrote:

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