I have a textbox in a UserForm that I'm using to add a text str to empty cells in a column. Using the following code:
I'd like to have excel look for the next empty cell the column. I found, what looks like to me, an elegant solution:![]()
Private Sub TextBox1_Change() Range("A2").Value = TextBox1.Value End Sub
I'm having trouble combining the codes and this is where I need help.![]()
Range("A1").End(xldown).Offset(1,0).Select
Thanks
Bookmarks