data bottom

  • Thread starter Thread starter dadda
  • Start date Start date
D

dadda

Good morning ;
I have a userform with many testboxes.I'd like that datas
enter in one of them,(textbox12)used for comments, come
after all the other datas in worksheet. I mean in the
bottom.
thank's
dadda
 
Can you pick out a column that is always filled?

with activesheet
.cells(.rows.count,"A").end(xlup).offset(1,0).value = me.textbox12.value
end with

It's like going to the bottom of column A (my example only) and hitting the End
key, then the upArrow key. Then dropping down one row (.offset(1,0)).
 
Back
Top