Programming a user form

**royUK** · 10-24-2009, 09:18 AM

You don't print a userform, you save the input to a formatted sheet & print the sheet. You already have the sheet.

Your code needs some major tidying. Remove all those small scroll commands. also, you don't need to select the rages, that's why the screen "flickers"

**ed ayers315** · 10-24-2009, 11:39 AM

That's great news. Can I have the sheet on one tab and the form on another or do I need to put my form parts over the cells they will be linked to fill in? Also, how do you move from one text box to the next one for the user to fill in?

Thank you

**Evagrius** · 10-24-2009, 11:47 AM

Hello,

If you use a userform, the activesheet can be any sheet. In other words, the form does not have to be near the cell or on the sheet where the data will eventually end up. Once the user has filled the desired textboxes / fields, they can click a command button that will transition the data from the form to the appropriate sheet.

To move from one field to the next on a Userform, the user simply tabs over. Simply adjust the tab index property of the userform.

RoyUk's sample Dataform should get you started . . .

**royUK** · 10-24-2009, 12:07 PM

Originally Posted by ed ayers315

That's great news. Can I have the sheet on one tab and the form on another or do I need to put my form parts over the cells they will be linked to fill in? Also, how do you move from one text box to the next one for the user to fill in?

Thank you

I think you need to read a little about userForms. You can also see an example here

http://excel-it.com/vba_examples.htm

Look at the database form

**ed ayers315** · 10-25-2009, 09:55 AM

What you suggested helped out a lot. I have attached a the file with 4 user forms linked to the Excel work sheet. I can not figure out How to get the user form to come up fro the user to fill out and then get to the next page.

Any suggestions would be appreciated, thanks.