Creating a Form

M

Marcia3641

Hi:
I am trying to create a database of people that attended my mortgage
seminar. But instead of giving them a 4x6 piece of paper to write their
information on, I will have my laptop at the booth and have them fill out the
information that is created in an excel form. It's just to hard to read
people's handwriting these days. I am trying to create a form that once
someone's fills it out their information will automatically go to another
part of the worksheet. But what I don't know how to do is get rid of the
previous person's information before the next person fills it out. I would
like to have some sort of submit but at the end which would then clear the
form, is that possible?
 
A

Anne Troy

P

PokerZan

yes there is. when after you have entered all your program events o
the cmdSubmit (command button) just add this line at the very end.

Call UserForm_Initialize

This will make it "re-initialize" the form after the other function
have taken place. I am still learning forms too though, so if anyon
knows fo a better way to do this, please don't hesitate to post it!

PZa
 
D

David McRitchie

Sounds like you are going to be sitting in the booth anyway, either way.

Haven't really looked at it but I think Martin Green's user forms
course material would help. Overall view looks like it would cover everything
you can download Spreadsheet and a PDF (or word) document.
http://www.fontstuff.com/downloads/index.htm#excelvba

Other tutorials on for Excel then VBA beginning at
http://www.mvps.org/dmcritchie//excel/excel.htm#tutorials
http://www.mvps.org/dmcritchie//excel/excel.htm#vbatutorials
but that was the only one I've listed as for forms.
 
A

Anne Troy

Sorry, Marcia. I assumed you meant a form on a worksheet and not a userform,
so... my instructions aren't any good if you've got a userform.
*******************
~Anne Troy

www.OfficeArticles.com
 
P

PokerZan

Martin Greens material are what I used when teaching myself how to build
UserForms, good stuff. In this tutorial it doesn't answer the question
that Marcia3641 had about clearing the form automatically once the
"submit" button was pushed.

I pretty much tried "re-intializing" the form at the end of its event
sequence and it worked. It seems that this was the correct thing to do
as I have not had any adverse effect happen (yet :) ).

PZan
 
M

Marcia3641

Thank for your feedback.

Okay, I have now created the form based on the website Anne Troy provided.
But the website indicates "lets move on to saving the infor into
spreadsheet", but doesn't have a link for me to click to find out how. HELP
PLEASE!
 
A

Anne Troy

I'm sorry, Marcia. I don't see that text anywhere in the article I gave you.
Perhaps it was someone else's article. If you can point out the link, maybe
I can help you continue...
*******************
~Anne Troy

www.OfficeArticles.com
 
A

Anne Troy

I still don't see it, Marcia. You say it says "Let's move on to saving the
information...", but there is nothing even remotely like that on that page.
So what's missing? What do you need to finish? The page tells you how to put
the button on your toolbar and how to run the macro from the button.

*******************
~Anne Troy

www.OfficeArticles.com
 
M

Marcia3641

Okay, no wonder I you don't see what I am talking about. The website I
included isn't the one I was following the directions for. Sorry about that,
as you can tell I am so confused.

Okay, I have created the userform and I hit F5 to run it to see if it work
but my drop-down list don't show up.
 
Top