Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MROUND an exsisting formula? | Excel Discussion (Misc queries) | |||
cannot open exsisting file | Excel Discussion (Misc queries) | |||
Adding to an exsisting formula | Excel Discussion (Misc queries) | |||
how do i add new sheets to an exsisting formula | Excel Discussion (Misc queries) | |||
adding text to a column of exsisting data | Excel Discussion (Misc queries) |