Edit exsisting data with userform
 

Currently the data is entered using a userform, this info is then placed onto
another worksheet, last empty row. That part works well!
I need a way to change/Edit any details last entered by using a userform.
Any ideas?
--
Geo

Edit exsisting data with userform
 

hi
you need to add code that calls the entry back to the form. it would be the
reverse of how the entry was put on the other sheet. you would have to
destinquish between a new entry and an existing entry. because the new entry
would go to the next available row but the existing entry would go back to it
original place. but with out more details, i'm afraid to suggest anything
further.
regards
FSt1

"Geo" wrote:

Currently the data is entered using a userform, this info is then placed onto
another worksheet, last empty row. That part works well!
I need a way to change/Edit any details last entered by using a userform.
Any ideas?
--
Geo

Edit exsisting data with userform
 

Thanks.
Maybe another way is to have a message box asking if the entries are
correct, if yes then it enters the data, if no then I can amend any entry.
How would that be done?
--
Geo


"FSt1" wrote:

hi
you need to add code that calls the entry back to the form. it would be the
reverse of how the entry was put on the other sheet. you would have to
destinquish between a new entry and an existing entry. because the new entry
would go to the next available row but the existing entry would go back to it
original place. but with out more details, i'm afraid to suggest anything
further.
regards
FSt1

"Geo" wrote:

Currently the data is entered using a userform, this info is then placed onto
another worksheet, last empty row. That part works well!
I need a way to change/Edit any details last entered by using a userform.
Any ideas?
--
Geo