I'm trying to insert a row from a userform data and am having trouble getting the data in the right part of the table. My table is called tractors in the worksheet called tractors.
Public Sub AddClassTractor_Click()
Sheets("Tractors").Activate
NextRow = Application.WorksheetFunction.CountA(Range("Tractors")) + 1
Cells(NextRow, 1) = MakeModel
Cells(NextRow, 2) = Daycab Or Sleeper
Cells(NextRow, 3) = AcqPrice
Unload Me
End Sub
Private Sub CancelButton_Click()
Unload Me
End Sub
Private Sub UserForm_Click()
End Sub
any help appreciated! thanks
Bookmarks