Is there a way to get forms to work in macros?
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, Tony
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.