Code for User form to Excel Sheet

[venkcris]

Hi,

I am trying to learn VBA. I created a Small project with some List and Text Boxes. What I am looking is when the user form is filled with data and I hit the save tab that needs to saved to a sheet in a excel sheet. How do I do that. Any help will be greatly appreciated.

[Norie]

It's pretty straightforward to transfer data to a worksheet.

Here's a very simple example.

Please Login or Register  to view this content.

Now obviously your setup is a bit more complicated, and the first thing I think you would want to do would be to find the row you wanted to put the data in.

Assuming that would be the next empty row on the List sheet you could use something like this.

Please Login or Register  to view this content.

Now you have the row to put the data in you can use that to put the data from each textbox/combobox in the relevant column.

For example, to put the value from the textbox APnumber into column A on the next empty row you would use this.

Please Login or Register  to view this content.

Similarly for the product texbox.

Please Login or Register  to view this content.

So you need similar code for all the relevant textboxes/comboboxes.

[venkcris]

Hi Norie,

I am able to copy it excel however it is over writing the data. Its not getting copied to the next line. Any suggestions on it please.

[Norie]

Can you post what you have now, or upload an updated workbook?

[venkcris]

Hi. Thanks for the reply. I am here with attaching my work book. I see when I select data or enter data it is showing in the excel sheet. However it is over writing. What I am looking for is when I hit the save button it should save and I can efresh the form and enter new data. Please help.