| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
passing parameters to OnAction
Hi Joe,
double quote and simple quote and Sub Name and 3 x double quote & Parameter & 3 x double quote and simple quote and double quote Example: .OnAction = "'MySub """ & Parameter & """'" Regards, MP "Joe" a écrit dans le message de ... I am using Xl 2002. Is it possible to pass a parameter to the Sub referenced in the OnAction property (i.e. OnAction="processMe(Argument1)"? TIA, -- Joe VBA Automation/VB/C++/Web and DB development |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
passing parameters to OnAction
What version of excel. I have seen posts here that indicate support for this
has been discontinued around xl2002 or one of the last service packs in xl2000. Post back with your experience and version if you will. -- Regards, Tom Ogilvy "Joe" wrote in message ... Thank you, sir. "Michel Pierron" wrote: Hi Joe, double quote and simple quote and Sub Name and 3 x double quote & Parameter & 3 x double quote and simple quote and double quote Example: .OnAction = "'MySub """ & Parameter & """'" Regards, MP "Joe" a écrit dans le message de ... I am using Xl 2002. Is it possible to pass a parameter to the Sub referenced in the OnAction property (i.e. OnAction="processMe(Argument1)"? TIA, -- Joe VBA Automation/VB/C++/Web and DB development |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
passing parameters to OnAction
Hi Tom,
Personally, I did not note a dysfunction (xl2000 and xl2002). Regards, MP "Tom Ogilvy" a écrit dans le message de ... What version of excel. I have seen posts here that indicate support for this has been discontinued around xl2002 or one of the last service packs in xl2000. Post back with your experience and version if you will. -- Regards, Tom Ogilvy "Joe" wrote in message ... Thank you, sir. "Michel Pierron" wrote: Hi Joe, double quote and simple quote and Sub Name and 3 x double quote & Parameter & 3 x double quote and simple quote and double quote Example: .OnAction = "'MySub """ & Parameter & """'" Regards, MP "Joe" a écrit dans le message de ... I am using Xl 2002. Is it possible to pass a parameter to the Sub referenced in the OnAction property (i.e. OnAction="processMe(Argument1)"? TIA, -- Joe VBA Automation/VB/C++/Web and DB development |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
passing parameters to OnAction
Thanks for the feedback.
-- Regards, Tom Ogilvy "Michel Pierron" wrote in message ... Hi Tom, Personally, I did not note a dysfunction (xl2000 and xl2002). Regards, MP "Tom Ogilvy" a écrit dans le message de ... What version of excel. I have seen posts here that indicate support for this has been discontinued around xl2002 or one of the last service packs in xl2000. Post back with your experience and version if you will. -- Regards, Tom Ogilvy "Joe" wrote in message ... Thank you, sir. "Michel Pierron" wrote: Hi Joe, double quote and simple quote and Sub Name and 3 x double quote & Parameter & 3 x double quote and simple quote and double quote Example: .OnAction = "'MySub """ & Parameter & """'" Regards, MP "Joe" a écrit dans le message de ... I am using Xl 2002. Is it possible to pass a parameter to the Sub referenced in the OnAction property (i.e. OnAction="processMe(Argument1)"? TIA, -- Joe VBA Automation/VB/C++/Web and DB development |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
passing parameters to OnAction
Tom,
I tried what Michel Pierron sugegsted and it worked just fine. Joe "Tom Ogilvy" wrote: Thanks for the feedback. -- Regards, Tom Ogilvy "Michel Pierron" wrote in message ... Hi Tom, Personally, I did not note a dysfunction (xl2000 and xl2002). Regards, MP "Tom Ogilvy" a écrit dans le message de ... What version of excel. I have seen posts here that indicate support for this has been discontinued around xl2002 or one of the last service packs in xl2000. Post back with your experience and version if you will. -- Regards, Tom Ogilvy "Joe" wrote in message ... Thank you, sir. "Michel Pierron" wrote: Hi Joe, double quote and simple quote and Sub Name and 3 x double quote & Parameter & 3 x double quote and simple quote and double quote Example: .OnAction = "'MySub """ & Parameter & """'" Regards, MP "Joe" a écrit dans le message de ... I am using Xl 2002. Is it possible to pass a parameter to the Sub referenced in the OnAction property (i.e. OnAction="processMe(Argument1)"? TIA, -- Joe VBA Automation/VB/C++/Web and DB development |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
passing parameters to OnAction
And version of Excel?
thanks. -- Regards, Tom Ogilvy "Joe" wrote in message ... Tom, I tried what Michel Pierron sugegsted and it worked just fine. Joe "Tom Ogilvy" wrote: Thanks for the feedback. -- Regards, Tom Ogilvy "Michel Pierron" wrote in message ... Hi Tom, Personally, I did not note a dysfunction (xl2000 and xl2002). Regards, MP "Tom Ogilvy" a écrit dans le message de ... What version of excel. I have seen posts here that indicate support for this has been discontinued around xl2002 or one of the last service packs in xl2000. Post back with your experience and version if you will. -- Regards, Tom Ogilvy "Joe" wrote in message ... Thank you, sir. "Michel Pierron" wrote: Hi Joe, double quote and simple quote and Sub Name and 3 x double quote & Parameter & 3 x double quote and simple quote and double quote Example: .OnAction = "'MySub """ & Parameter & """'" Regards, MP "Joe" a écrit dans le message de ... I am using Xl 2002. Is it possible to pass a parameter to the Sub referenced in the OnAction property (i.e. OnAction="processMe(Argument1)"? TIA, -- Joe VBA Automation/VB/C++/Web and DB development |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
passing parameters to OnAction
I just used this technique on Excel 2003 and it works fine but I have a
follow-up question: How would you use this technique to call a function with more than one parameter? Regards, Gaston "Tom Ogilvy" wrote: And version of Excel? thanks. -- Regards, Tom Ogilvy "Joe" wrote in message ... Tom, I tried what Michel Pierron sugegsted and it worked just fine. Joe "Tom Ogilvy" wrote: Thanks for the feedback. -- Regards, Tom Ogilvy "Michel Pierron" wrote in message ... Hi Tom, Personally, I did not note a dysfunction (xl2000 and xl2002). Regards, MP "Tom Ogilvy" a écrit dans le message de ... What version of excel. I have seen posts here that indicate support for this has been discontinued around xl2002 or one of the last service packs in xl2000. Post back with your experience and version if you will. -- Regards, Tom Ogilvy "Joe" wrote in message ... Thank you, sir. "Michel Pierron" wrote: Hi Joe, double quote and simple quote and Sub Name and 3 x double quote & Parameter & 3 x double quote and simple quote and double quote Example: .OnAction = "'MySub """ & Parameter & """'" Regards, MP "Joe" a écrit dans le message de ... I am using Xl 2002. Is it possible to pass a parameter to the Sub referenced in the OnAction property (i.e. OnAction="processMe(Argument1)"? TIA, -- Joe VBA Automation/VB/C++/Web and DB development |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
passing parameters to OnAction
To specify multiple parameters use a comma separated list. The final string
should look something like the following, where text is in double quotes and numbers are not in quotes: MyMacro "String1", 10, "String2" This translates to the following: ..OnAction = "MyMacro ""String1"", 10, ""String2""" If the values are in variables you would use the following: ..OnAction = "MyMacro """ & String1 & """," & myNumber & ", """ & String2 & """" -- John Green Sydney Australia "Gaston" wrote in message ... I just used this technique on Excel 2003 and it works fine but I have a follow-up question: How would you use this technique to call a function with more than one parameter? Regards, Gaston "Tom Ogilvy" wrote: And version of Excel? thanks. -- Regards, Tom Ogilvy "Joe" wrote in message ... Tom, I tried what Michel Pierron sugegsted and it worked just fine. Joe "Tom Ogilvy" wrote: Thanks for the feedback. -- Regards, Tom Ogilvy "Michel Pierron" wrote in message ... Hi Tom, Personally, I did not note a dysfunction (xl2000 and xl2002). Regards, MP "Tom Ogilvy" a écrit dans le message de ... What version of excel. I have seen posts here that indicate support for this has been discontinued around xl2002 or one of the last service packs in xl2000. Post back with your experience and version if you will. -- Regards, Tom Ogilvy "Joe" wrote in message ... Thank you, sir. "Michel Pierron" wrote: Hi Joe, double quote and simple quote and Sub Name and 3 x double quote & Parameter & 3 x double quote and simple quote and double quote Example: .OnAction = "'MySub """ & Parameter & """'" Regards, MP "Joe" a écrit dans le message de ... I am using Xl 2002. Is it possible to pass a parameter to the Sub referenced in the OnAction property (i.e. OnAction="processMe(Argument1)"? TIA, -- Joe VBA Automation/VB/C++/Web and DB development |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
passing parameters to OnAction
Thank You.
Gaston "John Green" wrote: To specify multiple parameters use a comma separated list. The final string should look something like the following, where text is in double quotes and numbers are not in quotes: MyMacro "String1", 10, "String2" This translates to the following: ..OnAction = "MyMacro ""String1"", 10, ""String2""" If the values are in variables you would use the following: ..OnAction = "MyMacro """ & String1 & """," & myNumber & ", """ & String2 & """" -- John Green Sydney Australia "Gaston" wrote in message ... I just used this technique on Excel 2003 and it works fine but I have a follow-up question: How would you use this technique to call a function with more than one parameter? Regards, Gaston "Tom Ogilvy" wrote: And version of Excel? thanks. -- Regards, Tom Ogilvy "Joe" wrote in message ... Tom, I tried what Michel Pierron sugegsted and it worked just fine. Joe "Tom Ogilvy" wrote: Thanks for the feedback. -- Regards, Tom Ogilvy "Michel Pierron" wrote in message ... Hi Tom, Personally, I did not note a dysfunction (xl2000 and xl2002). Regards, MP "Tom Ogilvy" a écrit dans le message de ... What version of excel. I have seen posts here that indicate support for this has been discontinued around xl2002 or one of the last service packs in xl2000. Post back with your experience and version if you will. -- Regards, Tom Ogilvy "Joe" wrote in message ... Thank you, sir. "Michel Pierron" wrote: Hi Joe, double quote and simple quote and Sub Name and 3 x double quote & Parameter & 3 x double quote and simple quote and double quote Example: .OnAction = "'MySub """ & Parameter & """'" Regards, MP "Joe" a écrit dans le message de ... I am using Xl 2002. Is it possible to pass a parameter to the Sub referenced in the OnAction property (i.e. OnAction="processMe(Argument1)"? TIA, -- Joe VBA Automation/VB/C++/Web and DB development |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Passing several parameters to OnAction property. | Excel Discussion (Misc queries) | |||
| OnAction of Menu Bar with variable parameters | Excel Discussion (Misc queries) | |||
| Set up OnAction of a Menu Bar button to a function with variable in the parameters | Excel Discussion (Misc queries) | |||
| Passing parameters | Excel Programming | |||
| Passing Parameters through OnAction | Excel Programming | |||
Linear Mode
