Henrybukowski
New Member
- Joined
- Apr 16, 2013
- Messages
- 29
My Excel document takes the form of a datasheet lines of entry, populated by a Userform, which transfers the data across to a new row
The complication is that each entry will change in some regards later down the line, and information needs to be updated.
Ideally, the practitioner should be able to edit the record in the user form, rather than the spreadsheet.
Therefore, is there any code which, for example clicking in a row, re-populates the User form so that the data can be amended and then put back into the row as a replacement?
I suppose for example this could take the form of an event handler upon double clicking in a persons record, or a command button from which you select the appropriate record from a 'Go to' interface.
Thanks in advance for any assistance.
Henry Bukowski
http://www.excelforum.com/excel-pro...orm-from-the-database-record.html#post4013155
The complication is that each entry will change in some regards later down the line, and information needs to be updated.
Ideally, the practitioner should be able to edit the record in the user form, rather than the spreadsheet.
Therefore, is there any code which, for example clicking in a row, re-populates the User form so that the data can be amended and then put back into the row as a replacement?
I suppose for example this could take the form of an event handler upon double clicking in a persons record, or a command button from which you select the appropriate record from a 'Go to' interface.
Thanks in advance for any assistance.
Henry Bukowski
http://www.excelforum.com/excel-pro...orm-from-the-database-record.html#post4013155