User form/vba assistance

[bfraser]

I have a workbook (Hui wrote most of the code, thanks again) w/a userform that allows the user to enter an equipment name a date and a technicians name into a table. Getting a little comfortable w/the code so I made some changes to the ws, just deleted a few cols that I didn't need and added one. Now the userform places all of the values from the userform on the first row. So much for being comfortable w/the code. Thought I post a link and get everyones input. I use the code on a similar/seperater wb w/out issues.

ps still working on my manager to foot the bill for excel school... stingy!!!


http://www.speedyshare.com/files/30495932/New_Asset_List-test.xlsm

 

[Hui]

Hi Bill

Update the Pmupdate sub as below

There only 3 small changes

[pre]

Private Sub pmupdate_Click()

Application.ScreenUpdating = True
Worksheets("Conv Schedule").Select
Worksheets("Conv Schedule").ListObjects("Table1").Range.AutoFilter Field:=2, Criteria1:=cbounit.Value

ActiveCell.SpecialCells(xlLastCell).Offset(, -4).Value = cbopmdate.Value
ActiveCell.SpecialCells(xlLastCell).Offset(, -1).Value = cbotechname.Value
Application.ScreenUpdating = True

ActiveSheet.ListObjects("Table1").Range.AutoFilter Field:=2
End Sub

[/pre]

 

[bfraser]

Thanks again.