Hey you Excel geniuses out there. I have a little problem that is
stumping me. I have a small excel program that uses 6 inputs that the
user changes, a button with VBA code and an output. When the user makes
their changes, they press the button and the new value is calculated
based on the VBA code and is spit out in the output field. I have about
10 copies of this button with 10 different output fields. This is simply
so the user can compare conditions, setups, try different combinations,
etc... without having to lose the previous output every time. HERE IS
THE PROBLEM - I am trying to create an "Update All" button. This button
would theoretically perform the function of all 10 other buttons
simultaneously and update everything. However, I don't know of any way
to make this one button reference the subroutines of the other 10.
Right now, I have to copy and paste all 10 copies of the code into the
code for he Update All button. When I do this, Excel says that there is
too much code and won't perform the function.
DOES ANYONE KNOW HOW TO SIMPLY REFERENCE THE SUBROUTINES FROM THE OTHER
BUTTONS RATHER THAN COPYING AND PASTING THE CODE?? This would greatly
help. Thank You

Gunman


--
gunman
------------------------------------------------------------------------
gunman's Profile: http://www.excelforum.com/member.php...o&userid=23994
View this thread: http://www.excelforum.com/showthread...hreadid=470870