Cells(Lrow, 10).Value = Me.Department_number.Value Cells(Lrow, 9).Value = Me.Employee_Number.Value Cells(Lrow, 8).Value = Me.allocated_wages.Value Cells(Lrow, 7).Value = Me.First_Name.Value Cells(Lrow, 6).Value = Me.Last_Name.Value Lrow = ws.Cells(Rows.Count, 6).End(xlUp).Offset(1, 0).Row Note, all fields in form are text boxes with the exception of allocated wages and employee type, which are both combo boxes Below is the code I have to add new employees (note i googled this part and edited it for my purpose): If anyone can help me, I would be so grateful. What I can't figure out is how to do the following:īe able to scroll backwards and forwards through all the employees and their data fieldsīe able to search on an Employee Name to show that particular record inthe user form for editingīe able to edit that particular employee's data fields (without it just creating a new record) I have it setup so that you can fill in data and add a new employee. Basically, trying to create a userform that allows someone to populate Employee data. Hi, I've been struggling with this all day.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |