Entering Text Box Data into Next Empty Cells

[Publicpenguin]

Hi Everyone,

I am caught in an areas where I have learned how to find the next available empty row by going far down my worksheet, counting up until I reach a filled row and then offsetting that value by 1 as seen here below:

NextRow = Sheet1.Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).Row

My difficuly lies in assigning the cells in this empty row the data a user can input in my text boxes; let's say there are 4 text boxes which need to be put into the following cells:

• Text box 1 (Text value) needs to be assigned next empy cell in column: A

• Text box 2 (Text value) needs to be assigned next empy cell in column: B (1 offset away from A)

• Text box 3 (Numeric value) needs to be assigned next empy cell in column: F (5 offsets away from A)

• Text box 4 (Numeric value) needs to be assigned next empy cell in column: H (7 offsets away from A)

How would I go about using my identified "NextRow" and then plug in these text box values into their appropriate cells down that row?

A big pre-emptive thank you for any guidance along this front.

- Publicpenguin

[protonLeah]

Please post the code ( workbook is better )
In the mean time:

Please Login or Register  to view this content.

[Jakobshavn]

See the macro in the attached workbook

[Publicpenguin]

Hi,

Understood. I believe I've attached the workbook appropriately here.

[protonLeah]

Please Login or Register  to view this content.

[Publicpenguin]

Hi ProtonLeah and Jakobshavn,

The array function is fantastic as it helps keep my assigned values with the same row as my row count. It took me a minute to grasp some ** the simple things such as the column size declaration, but overall this has been a huge help. Thank you for the help here.

- Publicpenguin

[protonLeah]

You're welcome