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