how can I run a function from a button?

Posted by sam on March 29, 2001 6:57 AM

hello:
I have a VBA function that works fine, but i can only access it from the function's dialogue. I would like to use a button to run it. How can I make it?. Thanks.

Posted by Rick M on March 29, 2001 12:38 PM

Go To Control toolbox and select the button, Place on the sheet. Right click "view code" paste your code. Done!