ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   move text from form textbox to next blank cell (https://www.excelbanter.com/excel-programming/335497-move-text-form-textbox-next-blank-cell.html)

Thomas

move text from form textbox to next blank cell
 
How do I move text from a form textbox to the next blank cell?

Henry[_5_]

move text from form textbox to next blank cell
 
Thomas,

If your entries don't have to be in any particular order:

Copy the contents of your textbox(es) into a row (say row 2, leaving row 1
for headers).
Insert row 2 (this moves row 2 down to row 3)
Do this in a loop until you've finished all your entries.

Henry

"thomas" wrote in message
...
How do I move text from a form textbox to the next blank cell?





All times are GMT +1. The time now is 11:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com