To put value from txtbox to cell?
 

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

--
Samic
-----------------------------------------------------------------------
Samick's Profile: http://www.excelforum.com/member.php...fo&userid=1642
View this thread: http://www.excelforum.com/showthread.php?threadid=27795

To put value from txtbox to cell?
 

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)


"Samick" wrote in message
...

Hello,

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

Thank you very much


--
Samick
------------------------------------------------------------------------
Samick's Profile:
http://www.excelforum.com/member.php...o&userid=16427
View this thread: http://www.excelforum.com/showthread...hreadid=277957