View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
Amber_D_Laws[_90_] Amber_D_Laws[_90_] is offline
external usenet poster
 
Posts: 1
Default Multipling the value of 3 text boxes


Well....that is a lot more simple, and practically what I thought it
would be!
The change event I want to attach this to is:
Sub cmbMethodName_Change()
will that matter, or can I just insert said code?

Thanks dok112!


dok112 Wrote:
You could also call a change event that is a little simplier.

Sub Multiply_Value()
On Error Resume Next
textbox4.value = textbox1.value * textbox2.value * textbox3.value
end sub

and then on the change event for each of the 3 textboxs, call the
Multiply_Value command.

The only difference in this one, is if any of the 3 boxes do not
contain a value, then box4 will not generate a value.



--
Amber_D_Laws
------------------------------------------------------------------------
Amber_D_Laws's Profile: http://www.excelforum.com/member.php...o&userid=30012
View this thread: http://www.excelforum.com/showthread...hreadid=513735