Using a form to edit data
 

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?

Using a form to edit data
 

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?

Using a form to edit data
 

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?

Using a form to edit data
 

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