MrExcel Publishing
Your One Stop for Excel Tips & Solutions


Posted by Kate on January 04, 2002 11:18 AM

I am unfamiliar with the userform and its functions as was wondering if it would be worth looking into to to accomplish the following:

I want the user to view a form, if you will, into which the user must enter information (7 or so "fields"). I then want that information to populate a template. It would essentially be creating a new document. I was then thinking of adding buttons that would call upon subroutines to save, print, email, etc.

Does the userform sound like a way to accomplish this, if it can be accomplished at all?


Posted by denis on January 04, 2002 1:24 PM


A userform can do it, I did a similar userform , prompting for certian textbox's to be filled and have 3 button's , print, reset form & close form