LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Passing Parameter with OnAction

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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Passing several parameters to OnAction property. LABKHAND Excel Discussion (Misc queries) 1 April 24th 09 08:02 PM
.onaction, passing arguments Neal Zimm Excel Programming 10 July 6th 07 04:46 PM
Buttons, onAction and Parameter [email protected] Excel Programming 2 January 19th 05 09:31 AM
passing parameters to OnAction Michel Pierron Excel Programming 8 October 29th 04 11:59 PM
Passing Parameters through OnAction Mark Bigelow Excel Programming 3 September 10th 03 12:53 AM


All times are GMT +1. The time now is 02:52 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"