VBA to insert data in the first empty row (not last rows)

[karimretina]

Hello everybody,

I have a work sheet ("Sheet2"), range (B2:F8) with no merged cells. I like to insert data from a userform text box called (Name) in the FIRST empty row of this range. I tried this code which is perfect to localize the first empty cell of the row, however it failed to insert the data. If you any idea to help me, it will be really appreciated.

Thank you and stay safe

[Logit]

.
From your description what you are saying is that TEXTBOX: txbName.Text is holding 7 words that you want to paste into
cells B2:B8 ... is that correct ?

[karimretina]

Hello Logit,

Thank you so much for your reply. Actually, I like to type some words in ("txbName") TEXTBOX, then to insert these words. by clicking a command button, in the first single empty cell of the range ("B2:B8"). and repeat it for anothe TEXTBOX to insert them in the next empty cell of the range ("C2:C8") and so on up to range ("F2:F" ). So in this figure, I a formula to select and insert data in row 4 cells.Attachment 676091

Take care

[karimretina]

I mean 7 TEXTBOXES to insert data in 7 CELLS of the selected row

[jindon]

First empty row of B2:F8....

a bit confusing.
If find first empty cell in B2:B8 then simply

Please Login or Register  to view this content.

[karimretina]

Hello Jindon,

Thank you so much for your reply. I have this work sheet (Sheet2), and I like to insert data from 7 TEXTBOXES into the cells of the first empty row.Attachment 676092

Stay safe

[jindon]

Your attachments are all invalid link, so can not open.

[karimretina]

Sorry, it is only 5 TEXTBOXES for 5 Cells of same row

[jindon]

Perhaps something like

Please Login or Register  to view this content.

TextBoxName should be replaced with the appropriate names....

[karimretina]

Sorry , I hope you cane get the image now

[jindon]

That's what the code I last posted should do.

[karimretina]

Hello jindon

thank you so much it works and I got very perfect result. Really appreciated.

Have a wonderful day

[jindon]

You are welcome and same to you.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

[karimretina]

Hello Jindon,

It is done

Karim