Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to multiply two values and round the result | Excel Discussion (Misc queries) | |||
multiply two numbers and show the answer in a textbox | Excel Discussion (Misc queries) | |||
Multiply one cell by a factor and make that result round | Excel Worksheet Functions | |||
Textbox updating other Textboxes | Excel Programming | |||
textbox result to label | Excel Programming |