Guide Line Required for Listbox

excelway

New Member
Joined
Jan 30, 2015
Messages
13
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
b81903b9ad.jpg
any experience person.Thanks
 

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.
Why does your image show:
Select Salary Month Jan 17
But then your image shows entering the value under Feb 17
 
Upvote 0
Yes, your are right .Actually first i generate the total days in Jan . i will be then deduct the total absents from the total days .I will then be put the remaining days under the month Jan-17 based on the selection from list box.I have all the other cods but i don't know how to put the balance days based on the listbox selection.
 
Last edited:
Upvote 0
Cross-posted here: Guide Line Required for Listbox

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to all the other threads (see rule #13 here: Forum Rules).

This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

For a more complete explanation on cross-posting, see here: Excelguru Help Site - A message to forum cross posters).
 
Upvote 0

Forum statistics

Threads
1,215,025
Messages
6,122,731
Members
449,093
Latest member
Mnur

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top