i need make a user form including 2 input box code and qty
cmd button saves code and qty to other sheet in own rows
is it possible anyway

--
Tuokk
-----------------------------------------------------------------------
Tuokki's Profile: http://www.excelforum.com/member.php...fo&userid=3094
View this thread: http://www.excelforum.com/showthread.php?threadid=50614

Hi,
Here is a very basic example: a Userform with two textboxes and a
command button. There is no error checking e.g. is the quantity numeric.

Data is written columns A and B starting in row 2; row 1 assumed to be
header row.

HTH

Private Sub CommandButton1_Click()

Dim ws1 As Worksheet

Set ws1 = Worksheets("Sheet1")

With ws1
nextrow = .Cells(Rows.Count, "A").End(xlUp).Row + 1 ' Next row in column A
.Cells(nextrow, 1) = TextBox1.Value ' Code
.Cells(nextrow, 2) = TextBox2.Value ' Qty
End With

End Sub


"Tuokki" wrote:


i need make a user form including 2 input box code and qty
cmd button saves code and qty to other sheet in own rows
is it possible anyway ?


--
Tuokki
------------------------------------------------------------------------
Tuokki's Profile: http://www.excelforum.com/member.php...o&userid=30944
View this thread: http://www.excelforum.com/showthread...hreadid=506146