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
Bookmarks