Updating VBA form with worksheet Data

[Oxygen Potassium]

I have a Userform built and would to use it to not only add new data but also update data. Adding data is not a problem, that works. But I am having trouble loading the data from the worksheet back into the userform to update it. The form is trigger by clicking on any row in column A. So if A2 was clicked, 2 would be myRow. What am I missing to load the already populated data into the form?

Please Login or Register  to view this content.

[davesexcel]

The code you use to update the sheet, can you place the same code you use in the initialize event to repopulate the userform controls?.

[Oxygen Potassium]

I was under the impression that

Please Login or Register  to view this content.

would repopulate the userform controls with the values from those cells?

[6StringJazzer]

First of all the name of your Sub is incorrect. It must be named

Please Login or Register  to view this content.

regardless of the actual name of the form. It must be located in the code module for the form.

Also note that this is run only when the form is first loaded. If you want to change the data after it's loaded, then you need to use

Please Login or Register  to view this content.

which will run each time Show is called on the form after it's loaded.

[Oxygen Potassium]

Oh wow how could I miss something so simple. Works like a charm now. Thank you very much!!