Copy Data - From Various textboxes to another sheet

[vaibhav2312]

Dear Experts

I want to copy data from userform1 to another sheet

For Example

Userform1 - Containing, Combobox2 to combobox9 & copy in to another sheet (Entrances) in column A ( Should be copy at last row )
Textbox11 to textbox18 & copy in to another sheet (Entrances) in column B ( Should be copy at last row )
Textbox21 to textbox28 & copy in to another sheet (Entrances) in column C ( Should be copy at last row )
Textbox31 to textbox38 & copy in to another sheet (Entrances) in column D ( Should be copy at last row )
Textbox41 to textbox48 & copy in to another sheet (Entrances) in column E ( Should be copy at last row )

The Excel workbook is attached for you ready reference. ( Click on purchase voucher to show userform1)

I have created a small code

Please Login or Register  to view this content.

Your help on this subject will be highly appreciated

Thanks in advance
Vaibhav2312

[watersev]

hi vaibhav2312, please check attachment. As I have not found CommandButton1 object I have created a new button named "Save to sheet". I hope I've understood you correctly

[vaibhav2312]

Dear Sir,

Perfect & Excellent, you did great job for me, but one more help is required in userform1 = textbox59 value should be copy into entrances sheet in from of other column (A,B,C,D) value should be copy into column "F". & if i am entering data into combox2 & Combox9, data not copying into last row

Please look into.

I hope you will do it definitely.

Thanks in advance
Vaibhav2312

[watersev]

please check attachment

[vaibhav2312]

Excellent
Thank you very much, but data of textbox59 copying up to 8 rows it should be copy equal to data of column E.

Hope my point is clear

Please help me out.

SAVE.jpg

Please Login or Register  to view this content.

Thanks in advance

[watersev]

if to assume that Product name has to be filled anyway:

Please Login or Register  to view this content.

[vaibhav2312]

Excellent

Working perfect as i wanted

Thank you very much

Reputation Added