Is there a way to get forms to work in macros?
Forms in macros
Jul 20, 2005
2 Replies
Edit your macro and use the menu Insert-->UserForm. Add controls and adjust properties similar to VB. Then add code to extract data from the form and send it to SW.
Good luck,
The problem wasn't creating the form, it was getting the form to work in a macro. The trick to this is to have a very simple main() subroutine.
sub main() load userform1 userform1.show end sub
If you don't do this SW chokes when trying to load a form whithout a module that has main() in it. As you can see I figured it out. Thanks for your time.
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required