Copy TextBox data to Worksheet in specific range

[matrixpom]

Good day all,

I am working with a code to copy a contractor details to a particular worksheet. On my first UserForm if you press the "Add Personnel" cmd button it takes you to a second userform "Contact & Qualification Details" on this UserForm I have 4 TextBoxes, when the data is entered I need this data to be copied to sheet "PAGE 2" in the relevant grid starting at A18 & then clear all textboxes for the next entry to be copied below the last, I have the code below & so far had no success, any assistance would be greatly appreciated, thank you all once again & have a great day - Marco

Please Login or Register  to view this content.

[Norie]

Should iColumn not be iRow here?

Please Login or Register  to view this content.

[matrixpom]

Hi Norie, I've tried both Column & Row, to no avail? The Code does however stop at "ws.Cells(iColumn, "A").Value = Me.TextBox1.Value" but just at a loss as to why? Thanks Norie - Marco

**Update** - Don't ask me why but I change the code to "Row" from "column" & yes you guessed it Norie...works perfectly, thanks for the advice, you're a star! Have a fantastic day! - Marco

[Norie]

No problem Marco.