Updating Worksheet from UserForm

[NetNinja]

Hello,

I have created a UserForm whereby clicking on various command buttons will pull information from a worksheet and populate the form. Once the form is populated, I would like the user to be able to make changes if necessary and then save the changes back to the worksheet. I am struggling with the update part.

Just to simplify this, I have created some dummy code, which is similar to the code I have.

Please Login or Register  to view this content.

I'm still very new to this and am confused about how to get the specific information back into the correct parts of the spreadsheet.

Any guidance would be greatly appreciated.

Many thanks,
NetNinja

[walruseggman]

I think you're almost there, try this simple change:

Please Login or Register  to view this content.

[NetNinja]

Thank you for your quick reply.

For the update button, does that mean I need to list everything under that click event, for example:

Please Login or Register  to view this content.

Or is there any easier way to get the information back into the worksheet?

[walruseggman]

Yes, unless there's some sort of pattern. But still, the code can't "know" which fields go where, so you generally have to spell it out. You can, however, shorten the syntax. From your code in post #3:

Please Login or Register  to view this content.

[NetNinja]

Thank you very much! I will try your shortened version. Less code will hopefully mean fewer errors. Thanks again.

[EssoExplJoe]

You can also use a public userdefined type which is defined in a code module, not the form.