Add data from userform to specific cells on worksheet

Hello again Excel Forum,

I am struggling to add data I have collected in a user form to exact cells in a spreadsheet. It is address information to display on an invoice. All the code I have been able to see thus far refers to looping the info into each subsequent row. I have 5 Text boxes with 4 of them to enter their collected data into ("E8:E13"). So far nothing works. Anybody got anything simple. NB It would be the same data field each time so I wouldn't need to x1up or down.
Thanks in advance.

Hi Arkadi, yes that is correct.

OK I don't get an error message but nothing happens! As for the 4 items I was hoping to automatically update this in the future to accomodate for multiple address lines. Currently I have left space for only one as it wont be used to post the invoice, just to identify the buyer.

This is what I have input thus far.

Private Sub ConfirmClientBtn_Click()

Dim ws As Worksheet

Set ws = Worksheets("SalesInvoice") 'change sheet name as needed
With ws
.Range("E8").Value = ConfirmedClntName.Text 'replace texbox names with the ones you want to use
.Range("E9").Value = ConfirmedClntAddr1.Text
.Range("E10").Value = ConfirmedClntCity.Text
.Range("E11").Value = ConfirmedClntPcode.Text
End With

I think I might need to clear the data and close the form?

Yes they are populated with the addresses pulled from another worksheet. I did have Unload Me but removed it to see if it was causing the problem as it didn't close either when I clicked the command button. I will clean up the module I'm working in as I could have left something that could cause an glitch from previous attempts. Thanks for your help and thanks for pointing me towards the rules.

Please Login or Register  to view this content.

Thanks Arkadi, got to fly now can I send this over tomorrow?

Hi Arkadi, how do I send this Excel Doc over to you? Via an attachment?

Please find a dummy copy attached with all the code so far for both 1 x module and 1 x userform. Thanks

Any joy, looking at that bit of code Arkadi?

No it wasn't there when I posted. . Another set of eyes makes all the difference, such a simple oversight!!! Thanks so much Arkadi, that solved it!!! On to the next bit. Appreciate the help.