I use a form to enter data pertaining to a project

I would like to use the same form to call up the entered data so that it may
be edited.

The entered data is currently pasted into a set selection of cells on one of
the sheets and the data is used elsewhere in the spreadsheet.

At present, I can only enter the data once and if one were to use the form
again it would overwrite everything.

Ideally I would use an edit button to call up the form containing the
already entered data that could then be edited.

Can anyone help?

Roger
What do you mean when you say "form"? Do you mean a UserForm or do you
have simply a layout in a worksheet to simulate a form to fill out? HTH
Otto
"Roger on Excel" wrote in message
...
I use a form to enter data pertaining to a project

I would like to use the same form to call up the entered data so that it
may
be edited.

The entered data is currently pasted into a set selection of cells on one
of
the sheets and the data is used elsewhere in the spreadsheet.

At present, I can only enter the data once and if one were to use the form
again it would overwrite everything.

Ideally I would use an edit button to call up the form containing the
already entered data that could then be edited.

Can anyone help?

I am sorry.

I mean a UserForm that was created in virtual basic

Roger

"Otto Moehrbach" wrote:

Roger
What do you mean when you say "form"? Do you mean a UserForm or do you
have simply a layout in a worksheet to simulate a form to fill out? HTH
Otto
"Roger on Excel" wrote in message
...
I use a form to enter data pertaining to a project

I would like to use the same form to call up the entered data so that it
may
be edited.

The entered data is currently pasted into a set selection of cells on one
of
the sheets and the data is used elsewhere in the spreadsheet.

At present, I can only enter the data once and if one were to use the form
again it would overwrite everything.

Ideally I would use an edit button to call up the form containing the
already entered data that could then be edited.

Can anyone help?

Instead of designing your own form, you may find using Data|Form easier.

And if that isn't enough, John Walkenbach has an enhanced data form:
http://j-walk.com/ss/dataform/index.htm

And the source code is available for a small fee ($20 USA, IIRC).



Roger on Excel wrote:

I use a form to enter data pertaining to a project

I would like to use the same form to call up the entered data so that it may
be edited.

The entered data is currently pasted into a set selection of cells on one of
the sheets and the data is used elsewhere in the spreadsheet.

At present, I can only enter the data once and if one were to use the form
again it would overwrite everything.

Ideally I would use an edit button to call up the form containing the
already entered data that could then be edited.

Can anyone help?

--

Dave Peterson