How to pass several variables to a macro using OnAction

  • Thread starter Thread starter Ziado
  • Start date Start date
Z

Ziado

Can you please point me to the right syntax when passing More than One
variable using OnAction to a macro?
Note that it works fine when passing one variable, but with more than
one it never works!...
Your help is greatly appreciated. I spent so much time on the web
looking for an answer but to no avail, and tried so many different
things and nothing seems to work!
Thanks
Ziado
 
I've passed variables to a macro by using named ranges. Have you looked at
that? Unfortunately, I don't have any examples here to look at to give you
more info.
 
Works for me as:

Rollit (bit), swcell, wscell, wslimit, col1, col2, dura

Put the second and subsequent parameters outside of the brackets.

--
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Passing several parameters to OnAction property. 1
How to create a bubble chart with more than 2 variables 0
Macro - onAction arguments 2
OnAction macro in another wb 2
Calling Procedure from OnAction 3
Need Adaptable Macro 9
.OnAction set value 6
VBA: How can I use a string variable as autofilter criteria? 4

Back
Top