Programming a user form

[ed ayers315]

I need help to get the macros right to do the following that it can not do now:

I would like the user to be able to pause in between input areas and do others things.

Need for the input length to be varible or grow with the information

Are these things possible?

[Evagrius]

Hi,

I would recomend a Userform rather than a series of unvalidated imput boxes that force the user to go through each one. A userform will allow the user to exit at will and may be easier to validate.



Consider RoyUK's site for an example of how this can be done.
http://www.excel-it.com/vba_examples.htm

[ed ayers315]

Thank you for your suggestion. I tried the user form approach but could not get it to print correctly. It would cut out some of the text box information and break in the middle of a page. I also needed the information on that user form to be compiled to a history.

Any advice on that would be great. I will check out J & R link.

Again thank you!

[royUK]

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]

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]

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]

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]

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.

[royUK]

Why 4 userforms?

Why save it as a template before it is finished?

You have added a Multipage whicj is fine, but you put the controls on the MultiPage Tabs, not separate UserForms.

This last is personal opinion, but I really don't think the bright coours in the UserForms are necessary

[ed ayers315]

All very good questions

1. I could not get a page break or make the page long enough. I did not think to go sideways until I starting answering you back.

2. I did that trying other things before your last reply.

3. I deleted that out and used macro buttons to move to each page. The reason for this is one user will use Page 1-2 and a different person will do 3 -4.


I'll try cutting the other pages and going sideways unless there is a way to go down further

[royUK]

I would stick to the 4 pages, your form is rather large and difficult to display. I have a widescreen laptop & it does no display well. Don't make the controls igger than necessary

[ed ayers315]

RoyUK,

Thank you very much for your help, I have a working template/form. I do have a couple new questions that I will start new thread/s.

Thank you.