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.
