How to attach function to a custom Menubar?

  • Thread starter Thread starter Malcom Jazz
  • Start date Start date
M

Malcom Jazz

Rob,
Its Great.
Thank you for your patiance and taking me out of a major problem.
However there is a small problem.

If I use your code as it is the result is nothing.
If I replace If Err.Number <> 0 to If Err.Number = 0 I get the prope
result.
Can you pl explain this or am I doing somthing wrong?

Secondly, How to use the same trick for the formula functions havin
morethen one arguments? I have got a function which takes 4 arguments
I am planning to use your solution for all my custom formul
functions.

With regards,
Malcom
 
First question... I think I made a mistake. You corrected it.

Second...
eg.
Selection.Formula = "=MyFunction(" & rngFirst.Address & ", " &
rngSecond.Address & ", " & rngThird.Address & ", " & rngFourth.Address & ")"
 
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

How to attach function to a custom Menubar? 1
How to attach function to a custom Menubar? 1
function with collection of custom objects as results 0
Custom function for vlookup 11
Autocomplete Custom Functions and functions arguments 1
Any way to use "standard" Excel functions inside VBA functions 4
custom function - finding cell address 4
Custom MenuBar 2

Back
Top