MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Button assignment


Posted by alfredo sanchez on December 12, 2001 8:13 PM

Hi!
Can anyone tell me if there's a way to assign a custom button to a user defined function (not a sub)?
Thanks.


Posted by Juan Pablo G. on December 12, 2001 8:15 PM

Not that i know of. Why do you need to do that ? (NT)

Posted by alfredo sanchez on December 12, 2001 8:22 PM

Re: Not that i know of. Why do you need to do that ? (NT)

I have managed to get a function to work, and was seeking for an easier way to apply it. Actually I have to select it from Fx button>User defined Functions.

Posted by Juan Pablo G. on December 12, 2001 8:34 PM

Re: Not that i know of. Why do you need to do that ? (NT)

You could create a button that Pasted the function to the activecell...

ActiveCell.Formula = "=YOURFORMULA(A1,A2,A3)"

Juan Pablo G.