Programming a user form

**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.