Updating Multiple rows with Userform

Question

Hi,

I am working on a project. I use the following codes to enter Customer's Orders into the Sales Table on Excel through a Userform;

lRow = ws.Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).Row

    With ws

        .Cells(lRow, 1).Value = Me.Data1.Value

        .Cells(lRow, 2).Value = Me.Data2.Value

        .Cells(lRow, 3).Value = Me.Data3.Value

        .Cells(lRow, 4).Value = Me.Data4.Value

        .Cells(lRow, 5).Value = Me.Data5.Value

        .Cells(lRow, 6).Value = Me.Data6.Value

        .Cells(lRow, 7).Value = Me.Data7.Value

        .Cells(lRow, 8).Value = Me.Data8.Value

        .Cells(lRow, 9).Value = Me.Data9.Value

        .Cells(lRow, 10).Value = Me.Data10.Value

    End With

The Code above can only update one record in a row at a time. I can only enter one Product per Customer which is entered in a row. I want to be able to enter various products for one customer and post to different rows.

What do I do?

Answer 1

Ok. Thanks for your assistance.

Answer 2

This is not really the venue for that kind of assistance. You are looking for a consultant who can guide you through the project. Such an assignment require a lot of discussion before you even begin. That means time and money.

Answer 3

I have not done a project of such before. All I have done is to be able to update a Table on Excel with VBA and Userform and it is one item at a time. I can do the same project on the Excel Sheet and I can update multiple rows at the same time but I want to try it out on a userform through VBA. I can't say how fluent I am on VBA and Excel Database facilities. I am here to learn and that was why I joined the community. This is my first project of this nature. Your help will be highly appreciated.

Answer 4

I have built many such SYSTEMS using Excel Userforms and VBA. My impression is that you have no idea how big an exercise you are about to embark on. Are you fluent in VBA, Userforms and Excel database facilities?