Mohammad Ishaq
Member
Hi to everyone,
Dear friends I am working on an excel vba project.i have done everything successfully but I am facing a problem.
I have one sheet on excel(Attendance) , one userfom where I have one list box with three colums i.e No,ID,Employee Name , Disignation and one text box to put the no of absents.All the items on the list box are already available in the excel sheet.I mean I don’t want to select any item and copy them to sheet. I just want that when someone enter the no of absents in the text box,this no should appear on the excel sheet (Attendence) based on ID.For better understand I have attached a screen shot.Please guide me by any experience person.Thanks![SA.JPG SA.JPG](https://chandoo.org/forum/data/attachments/37/37451-888a225ae5004b5daa4ea9408ba57e9f.jpg)
Dear friends I am working on an excel vba project.i have done everything successfully but I am facing a problem.
I have one sheet on excel(Attendance) , one userfom where I have one list box with three colums i.e No,ID,Employee Name , Disignation and one text box to put the no of absents.All the items on the list box are already available in the excel sheet.I mean I don’t want to select any item and copy them to sheet. I just want that when someone enter the no of absents in the text box,this no should appear on the excel sheet (Attendence) based on ID.For better understand I have attached a screen shot.Please guide me by any experience person.Thanks
![SA.JPG SA.JPG](https://chandoo.org/forum/data/attachments/37/37451-888a225ae5004b5daa4ea9408ba57e9f.jpg)