How do I pass a parameter to a Sub from OnAction?

<button id="btnTest" label="Test Switchboard" size="large"
onAction="Switchboard" /

I have an AddIn that was written for Exce 2000 that I am trying to
migrate to 2007. In it are sveral procedures that are called by other
processes and/or menu buttons.

Since I have to have to add : "control As IRibbonControl" to each
procedure, how do I use the same procedure throughout the application
and still call them from the ribbon?

It seems to me the easiest way, is to pass a parameter to a
swithchboard that tells me which button was clicked then call the
procedure from the switchboard. This way the actual procedure remains
unchanged.

Excel 2007

Thanks
Mike

goshute used his keyboard to write :
How do I pass a parameter to a Sub from OnAction?

<button id="btnTest" label="Test Switchboard" size="large"
onAction="Switchboard" /

I have an AddIn that was written for Exce 2000 that I am trying to
migrate to 2007. In it are sveral procedures that are called by other
processes and/or menu buttons.

Since I have to have to add : "control As IRibbonControl" to each
procedure, how do I use the same procedure throughout the application
and still call them from the ribbon?

It seems to me the easiest way, is to pass a parameter to a
swithchboard that tells me which button was clicked then call the
procedure from the switchboard. This way the actual procedure remains
unchanged.

Excel 2007

Thanks
Mike

Try putting the parameter in the 'Tag' OR 'Parameter' property. Then
have your procedure query the parameter. More appropriately, use an
entry-point procedure for each button and have the entry-point
procedure pass any parameters required by the called procedure. This
way, your processes are reusable since they require a caller because
they are never run directly from a button. I store entry-point
procedures in a standard module named "mEntryPoints". I store my
process procedures in whatever module they best fit (Context-wise).

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

On Jul 16, 1:48*pm, GS wrote:
goshute used his keyboard to write :





How do I pass a parameter to a Sub from OnAction?

<button id="btnTest" label="Test Switchboard" size="large"
onAction="Switchboard" /

I have an AddIn that was written for Exce 2000 that I am trying to
migrate to 2007. In it are sveral procedures that are called by other
processes and/or menu buttons.

Since I have to have to add : "control As IRibbonControl" to each
procedure, how do I use the same procedure throughout the application
and still call them from the ribbon?

It seems to me the easiest way, is to pass a parameter to a
swithchboard that tells me which button was clicked then call the
procedure from the switchboard. This way the actual procedure remains
unchanged.

Excel 2007

Thanks
Mike

Try putting the parameter in the 'Tag' OR 'Parameter' property. Then
have your procedure query the parameter. More appropriately, use an
entry-point procedure for each button and have the entry-point
procedure pass any parameters required by the called procedure. This
way, your processes are reusable since they require a caller because
they are never run directly from a button. I store entry-point
procedures in a standard module named "mEntryPoints". I store my
process procedures in whatever module they best fit (Context-wise).

--
Garry

Free usenet access athttp://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc- Hide quoted text -

- Show quoted text -

Thanks works great.

You're welcome! Glad to help...

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc