Import various cell values to user form

[ipbr21054]

Job for tomorrow but just asking whilst I have the idea in my head.

I’m going to import data from my worksheet to a user form.

Customers name will be in column A
Then across that row is values in each cell.
I don’t want to import entire row to user form as some of the values are not required.

As each customer is on a different row I can’t import by using say reference B3 B4 etc etc because the next customer I wish to import will be say F33 F36
So this is why I mentioned the customer is in column A to maybe use as a reference.

Example of what I’m thinking of doing but not sure how to right it.

TOM JONES is on row 20 & I wish to copy the values from A21 A22 A25 now as mentioned I can use the range option so can we import like say,
Active cell +1 = user form Textbox 7
Active cell +2 = user form Textbox 9
Active cell +5 = user form Textbox 11

Each time I wish to import it will then use customers name & whatever cells to the right I’m planning on using +1 +5 etc.

Makes sense ?
Thanks.

 

[ipbr21054]

I’ve now done this using the code shown.

Me.TextBox1.Value = Cells(ActiveCell.Row, 18).Value