Creating Forms in Excel

[Greengard]

Can anyone recommed a good book/chapter to learn how to creat a form in
excell that will fill in a second document?

 

[Bob Phillips]

Peter Aiken Articles:
Part I
http://msdn.microsoft.com/library/en-us/dnoffpro01/html/IntroductiontoUserFormsPartI.asp

Part II
http://msdn.microsoft.com/library/en-us/dnoffsol02/html/IntroductiontoUserFormsPartII.asp

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Gord Dibben]

Follow Debra's instructions and illustrations and you will be good to go.

http://www.contextures.on.ca/xlUserForm01.html


Gord Dibben MS Excel MVP

 

[Tita_Guera]

I'm interested in creating forms also--tried the links below but they don't
work--when you get a moment, if you would please post the revised links.
Thank you very much! Maria

 

[Gord Dibben]

I don't understand your question about viewing and editing existing captured
data in a "flat file"

Might be an "old guy" thing but I, for one, need more detail.


Gord

 

[Gord Dibben]

Gaylen

My skills in this area are very limited and I don't work with UserForms on a
regular basis so not sure what you can do with them.

I would suggest waiting for someone with the expertise to jump in or perhaps
you could re-post in the Programming news group.


Gord

 

[Dave Peterson]

If you're not showing all 71 of those columns, then you may want to look at
excel's built in version:
Data|Form (in xl2003 menus)

If that's not enough...
You could look at John Walkenbach's enhanced data form:
http://j-walk.com/ss/dataform/index.htm

The source code is available for a small fee ($20 USA, IIRC). So you can modify
it as much as you want.

And if you want to design your own:

Debra Dalgleish shares some tips:
http://contextures.com/xlUserForm01.html

=================
Personally, I like to do my data entry directly into the worksheet itself. I
find that I can use data|Filter|autofilter and show/hide what I want. I can
sort the way I like.

I can enter a value into multiple cells at once. I can drag values. I can hide
columns that I don't want to see.

 

[Dave Peterson]

Debra does nice work!

You may want to add her site to your favorites. There's lots more helpful
information there.