A source for learning how to use User Forms?

[matonanjin]

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.

 

[Skyybot]

Very small tidbit... UserForm.TextBox1 = Workbooks("Workbook_Name.xlsx").Worksheets("Sheet1").Range("A1") and vice versa.

 

[Skyybot]

You can do a Google search for Excel VBA User Form and get a lot of useful results.

 

[jolivanes]

Is this what you mean?

Private Sub CommandButton1_Click()
    Me.TextBox1 = Sheets("Sheet1").Range("A1").Value
End Sub

While the UserForm is open, change the text in the TextBox and run this

Private Sub CommandButton2_Click()
    Sheets("Sheet1").Range("D5").Value = Me.TextBox1
End Sub

 

[Skyybot]

Yes, but you should qualify the Workbook that the sheet is in.

Workbooks("Workbook_Name.xlsx").Sheets("Sheet1").Range("D5")

 

[Skyybot]

Oh, sorry @jolivanes . I didn't notice that was you and not OP.

 

[jolivanes]

No sorry needed because you are right.
I have the bad habit thinking that the OP's should do that but that is of course not so.
Thanks for that Skybot.