Details: I have over 100 identical worksheets with the same combo box user
control scrollbar on each Excel worksheet to allow user to choose from one of
6 print options. I want to use a call procedure in each visual basic sheet
so that I can maintain the detailed print option procedures in one module
rather than in each sheet. I successfully experimented with a command button
using the €œclick€� event control that called a procedure in another module.
The only difference I can see is that my combo box uses the €œchange€� event
control with 6 different events based on the user selection. I cant figure
out the syntax to make the call procedure work. Hopefully the lingo I used
is accurate in describing my question.