Guide Line Required for Listbox

[M-ishaq]

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

[Richard Buttrey]

Presumably that's a typo since your UF shows January 2017 as the operative month yet you're pointing to a February column on the worksheet.
You'll need to create two variables to identify the row and column you need.

So the Row value will be the Column(2) value of your listbox selection and the column number will be the Salary month value from the date/calendar box on the UF.

Then it should be a fairly trivial matter to find the ID value returned by Column(2) listbox in the sheet's column B, and similarly find the Date in Row 1 of the sheet and using those two coordinates add the absentee number to the sheet.

[AliGW]

Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).