Hi everybody,
I have a Wsheet with 8 textboxes. The first 5, when saving the data to the wsheet from the userform has the following code:
ActiveCell.Offset(0, 3) = TextBox5
The last 3 textboxes have a different code:
ActiveCell.Offset(1, 5) = TextBox9
My objective is that the data from the 3 last textboxes goes to the three rows below and, when i enter a new record, the data goes to the row below the row where the textbox11 was inserted.
My problem is that, when i insert a new record, the data from those 3 textboxes dissapeare.
Can anyone help me with this?
I think that the attach file should explain it better
Bookmarks