G
Guest
Can anyone recommed a good book/chapter to learn how to creat a form in
excell that will fill in a second document?
excell that will fill in a second document?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
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)
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)
G
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
http://www.contextures.on.ca/xlUserForm01.html
Gord Dibben MS Excel MVP
T
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
work--when you get a moment, if you would please post the revised links.
Thank you very much! Maria
G
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
data in a "flat file"
Might be an "old guy" thing but I, for one, need more detail.
Gord
G
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
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
D
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.
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.
D
Dave Peterson
Debra does nice work!
You may want to add her site to your favorites. There's lots more helpful
information there.
You may want to add her site to your favorites. There's lots more helpful
information there.