Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA: Update worksheet when txtBox data changes. | Excel Worksheet Functions | |||
VBA: Update worksheet when txtBox data changes. | Excel Worksheet Functions | |||
VBA: Update worksheet when txtBox data changes. | Excel Worksheet Functions | |||
Validateing a txtbox from form | Excel Programming | |||
txtbox code | Excel Programming |