Debra does nice work!

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

Gaylen wrote:

Dave I'm using all 71 colums and that was the reason why i've created a user
form becuase excel's data form could handle the size.

Presently i'do make use of auto filter and advanced filter. That why i was
thinking that if i created a form to capture the data, why can't i use the
same form to edit the data or modify the data or add to the data that was
partially entered.

Thanks to Debra Dalgleish instructions I was Able to create the form to
capture the data.

"Dave Peterson" wrote:

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.




Gaylen wrote:

I've create a form to capture my invoice into a worksheet. on the worksheet
i've added another column named Comment.

Now i want to view the invoice and enter comment like "service ok", "canceld"

The problem of doing it in the worksheet self is a little problematic
because the worksheet contains over 71 columns and over a 1000 rows.

I was wondering if the form that i've created in VBA can be used to view
information that was alredy entered and add comment or edit the comment

"Gord Dibben" wrote:

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

On Mon, 26 Jan 2009 03:56:01 -0800, Gaylen wrote:

Thank you this link was perfect. I've created my first form successful and
capture data.

Now how do i go about in creating or using a form to view and edit the data
that is already capture in to excel flat file.

"Gord Dibben" wrote:

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

On Fri, 18 May 2007 13:33:02 -0700, Greengard
wrote:

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





--

Dave Peterson


--

Dave Peterson