Archive of Mr Excel Message Board

Back to Controls in Excel archive index
Back to archive home

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.

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

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

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

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

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.

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

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

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

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

Juan Pablo G.

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.