To put value from txtbox to cell?

[Samick]

Hello,

please, I need in Excel put value to textbox and while I click Comman
button, it will fill in a cell. Next run should fill in cell one lin
down. (first A1, second A2, third A3......). Please, can you write
source code for it?

Thank you very muc

 

[Bob Phillips]

With Worksheet("Sheet1")
cLastRow = .Cells(Rows.Count,"A").End(xlUp).Row
.Range("A" & cLastRow+1).Value = Me.Textbox1.Text
End With


--

HTH

RP
(remove nothere from the email address if mailing direct)