MrExcel Publishing
Your One Stop for Excel Tips & Solutions

VB Code in Form to call function?


Posted by Chris on December 03, 2001 9:28 PM

Hi -

Can anyone tell me how to I need to set up code within a form so that it can call a function?

Where do I store the function code so that it can be picked up -- I tried a module and it didn't work...

Thanks,
Chris


Posted by Tom D. on December 03, 2001 11:14 PM

From the toolbar for forms, put in a CommandButton. Click on it and you should be put at the macro of "CommandButton1_Click()". Write your function there.