A Source to Study VBA User Forms

I have such a broad scope question I thought it might just be best to spend some time learning VBA User forms.

The question is this. When I design and then Userform.show I of course use the userform initialize to have the user put all the stuff in the text boxes and choose from the comboxes and then stuff that into the different sheet cells.

But then how do I use the userform to grab stuff from sheet cells and then have the user modify it and put back into the sheet? I can't use the initialize event again. I don't think I can.

I can't even come up with some code to post here to have you guys rip on me. If you can just point me in a couple directions to study I reasoned might be best staring point.

Originally Posted by torachan

attached a simple demo of the basics (Add, Update, Delete).
to add a new entry first press 'Clear' then put your data into the three fields and press 'Add'
the rest should be intuitive and the code is readable and easy to follow.

torachan, thank you for providing an absolute perfect study guide for me to learn what I am trying to do. I am going to take this and do exactly that: STUDY! Thus far I have only glanced at the code and I have played with the form just a little. But I already know it is exactly what I need.

Thank you again!