Smart Attendance Manager in Excel VBA

#UserForm #VBAtutorial
Hello Friends,
In this video, you will learn how to create a Smart and automated Attendance Manager Tool using Excel VBA. We have explained step by step each and every feature. We have used in this form we have given three different pages - Mark attendance, Employee Master and Attendance Codes. You can mark the attendance for multiple employee using the Mark Bulk attendance feature available in employee master page.
Please download the practice file from below given link:
www.pk-anexcel...
Download our free Excel utility Tool and improve your productivity:
www.pk-anexcel...
See our Excel Products:
www.pk-anexcel...
Visit to learn more:
Chart and Visualizations: www.pk-anexcel...
VBA Course: www.pk-anexcel...
Download useful Templates: www.pk-anexcel...
Dashboards: www.pk-anexcel...
Watch the best info-graphics and dynamic charts from below link:
• Dynamic Graphs
Learn and free download best excel Dashboard template:
• Excel Dashboards
Learn Step by Step VBA:
• VBA Tutorial
Website:
www.PK-AnExcel...
Facebook:
/ pkanexcelexpert
Telegram:
t.me/joinchat/...
Pinterest:
/ pkanexcelexpert
Send me your queries on telegram:
@PKanExcelExpert
************ Suggested Books ********
VBA: amzn.to/2TMMikX
Excel Dashboard: amzn.to/2WZi2Fj
Power Query: amzn.to/2Ibd7xR
Power Pivot and Power BI: amzn.to/2DCg8BB
Exam Ref 70-778 (Power BI): amzn.to/2GnWYTN
************ My Stuff ***************
Mic : amzn.to/2TLnF88
Video Editor: screencast-o-m...

[@gerrysotto9688]

I like your all videos tutorial, step by step, easy to understand.

[@PKAnExcelExpert]

Glad you like them!

[@kevindickson5519]

I've never commented before on a RUclips video, but I feel I have to for this one.
After going through dozens of other tutorials which have just led to confusion, this one hits the nail on the head perfectly.
I'm creating a project task manager to update each support card with daily notes, and this is exactly what I need.
Thank you for your hard working in making this video, I am very appreciative.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@sharvari.s.vichare]

@@PKAnExcelExpert Good PK

[@routjadu]

Awsome tutorial. Please add to show monthly attendance register for every Employee id & for all with search.

[@thekushwaharahul]

This is another master class, done and dusted. Are you also suggesting your expertise for creating own requirements

[@researchr]

I want to say " Absolutely Extraordinary Mind blowing Sir "

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@RafiqKhan-xp2ic]

ماشاءاللہ بہت خوب

[@tonisharma9733]

Thanks you sir for providing free smart attendance sheets

[@PKAnExcelExpert]

Most welcome

[@noorwazir]

It Is the best program for every user
All under one roof
But if the discount column is increased in the Sale and purchase form, it will be easier.
Because sometimes a discount is given to the customer.
like Product Name Type Rate Qty Discount Amount
Calpol Tab Sale 20 10 5%

[@vincysigma]

Excellent Sir.. you are too genius..

[@PKAnExcelExpert]

Thank you! Cheers!

[@PeeyushNagpal]

Thanks a lot sharing for your hardwork.

[@PKAnExcelExpert]

Most welcome

[@ghaivirendesingh]

amazing After Watching Lots of Video i found finally useful one , Thanks For Shear

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@hamidullahrahimi44]

Best of luck PK

[@PKAnExcelExpert]

Thanks

[@rickkeev4919]

OUTSTANDING!! So many methods explained; awesome vision and ingenuity.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@MeAmiyaMohanty]

Thanks. So clearly you made it easy and understandable. Just awesome brother

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@razalihussin2498]

Firstly i would like to say thank you for sharing your knowledge with us...
Why i cannot run sub...always getting message "Run-time error '9': Subscript out of range

[@chaalakansilva9805]

How to include a delete function to this userform

[@DocWhovian_71]

I have the same question!

[@diya2909]

Dear sir I like your all videos very much and I learnt a lot...I request you make a video on advance multi page userform with contains 5 to 6 pages, add button ,search,update,delete buttons and data should be sent only one sheet. Please.

[@mayengbamluwang9699]

Awesome... Can you also make a banking software.?? With all important contents.

[@PKAnExcelExpert]

Thanks. I will try to create

[@shirleytaylor8234]

I have been looking for a better attendance manager for about 4 months. I tried several didn't like them at all. This is exactly what i needed thank you so much Sir. Could you do on for Breaks only. My employees get two 15 minute breaks that the company pays for. I'm trying to find a better sheet to calculate their time over the breaks so I can subtract that time over from their pay checks.

[@baishalimitra9720]

Mind-blowing sir. Really It's helpful for me.
Could you please do another one video for "timesheet status for employees" every week.

[@RadheshyamaHari]

Dear Expert,
Present is marking by add button, but i want it can automatically add by just entering employee id

[@rez2109]

Impressive

[@wahabhaneefa4172]

Sir, First of thanking you and your tutorials are very useful. Sir! could you guide me to count the searched data in the list box like how many female or male like it

[@rezajabbarzadeh8722]

thank you bro

[@PKAnExcelExpert]

Most welcome

[@ahmedelhenawey3967]

Thank you

[@PKAnExcelExpert]

Most welcome🙏

[@coolag74]

Fantabulous. Hats off to you...

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@sharvari.s.vichare]

Good PK
Useful

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@sharvari.s.vichare]

Good PK.
You are genius in POwer bi and excel

[@issifuashong4904]

Thanks a lot for this video. But i want to know why you added +2 to the listindex of the update button.
Thank You

[@chrisfotoglidis437]

Thank you for the knowledge you offer

[@honnurswamy6292]

Can I delete attendance records please add delete button 🔵

[@PKAnExcelExpert]

I will add it in the next version of it

[@creativeideas6469]

Can we put multiple employees present on a single click?

[@PKAnExcelExpert]

You can see our other Attendance related tools:
ruclips.net/video/icPz-OW9LkE/видео.html
ruclips.net/video/PnZrH-fvMto/видео.html

[@Automation-Nepal]

🙏Hi Thanks a lot for very nice sheet. I would like to give a suggestion please add update it with overtime entry also.

[@deepakkumarchauhan4656]

very nice video , thank you sir,

[@delhicyclingassociation4094]

Hello PK, a very informative and elaborate video. if you could add a delete option for the employee it would be nice.

[@PKAnExcelExpert]

Thanks for your valuable feedback. I will add delete button in next iteration.

[@codalisa007]

Excellent tutorial.

[@LotsOfTrade]

Awesome.. talented.. Keep up the good work.. thumbs up..

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@karuppusamyn515]

Oh...! Super sir.👍👍👍

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@LarsIngeHolen]

Super great 👏👏 thanks 🙏🙏

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@vijaysahal4556]

superb sir 👍👍👍👍👍I want to learn nd bcme in excel vba plz guide me sir what I do which step bcz me bigner but I want to learn like expert so plz guide

[@SM-tz1hc]

Please dear PK ,tell me hiw to hide excel windows from userform and showing only userform in the desk

[@tusharkadam3762]

Thanks videos are very useful and easy to understand!
Is there any possibility we can set different alignment for each column in list box
e.g. column 1 as left then 2nd column as center and so on..

[@PKAnExcelExpert]

Thanks for your valuable feedback. Alignment can be for all columns together

[@tusharkadam3762]

So you mean it will be the same for all the columns and we can't set the it for individual level

[@puthdarakim1175]

I like the same as Easy POS, and refresh item list table from quickbooks desktop, keep daily sales save to excel then do day end cash sales reports,...

[@PKAnExcelExpert]

Please check below given video, if it match your requirements:
ruclips.net/video/yd5BDFjFyxA/видео.html

[@MohanYGK]

Simply superb.

[@nerijusb4267]

Fantastic - amazing job. A lot learned from you.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@abdrachman4825]

Thank you sir .. this is very useful for me

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@teachinggura4308]

Thanks you... But I have error massage "could not set the row source property. Invalid property value" how to fix this sir...

[@Naruto65943]

Hi bro. Your excel videos are very learning and useful for me. I want to know how do I add "In time and Our Time" in the place of "Present".?

[@hassankazerooni1399]

Dear Pk, its very good format but i want to know how to print one month total attendance in one page (like Employee abc attendance from date 1 to 31 in one line and if there are 30 employee then all monthly attendance should be in one page)
Thanks

[@PKAnExcelExpert]

Thanks for your valuable feedback. I will definitely try to consider this in next iteration

[@hassankazerooni1399]

@@PKAnExcelExpert Thanks a lot for prompt reply

[@RS-nf1bh]

Sir you are really awesome.. i salute your skills.. i also want to learn VBA.. please guide me how can i take class from you?

[@tupolivetz4168]

fantastic...!!!...Good...keep it up Bro

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@sanjayrohilla2093]

amazing video ,thanks SIR

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@Shahul1982]

Hi Mr. PK, hope you Doing well, while writing the code to display the list box I am getting " Run Time Error - '380' : Could not set the Rowsource Properly, Invalid Property value " Please help me to fix the same

[@MindTeaser-TV]

Sub Attendence_Code_List()
Dim sh As Worksheet
Set sh = ThisWorkbook.Sheets("AttendenceCode")
Dim last_row As Long
last_row = Application.WorksheetFunction.CountA(sh.Range("A:A"))
If last_row = 1 Then last_row = 2
With Me.ListBox3
.ColumnHeads = True
.ColumnCount = 3
.ColumnWidths = "100,150,150"
.RowSource = sh.Name & "!A2:C" & last_row
End With
End Sub
Replace this in code

[@dipaksolanki2679]

Sir please make video on prevantive mantainance reminder userform and planning work done.

[@PKAnExcelExpert]

Will try

[@arunpatil833]

In list box how many maximum columns add ....i have use this 15 above

[@albanoteles4924]

TOP!Thanks very useful.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@hoselleotajale1293]

run time error 1004 unable to get the match property of worksheet function class......how can we solve it

[@nihaaan]

Got stuck with the same error after hours of following this tutorial :(( Were you able to resolve this issue???

[@eirabriennestark2166]

Sir, can you please tell how can we change the EMPLOYEE ID dropdown selection (data validation) into manually encoding the employee ID? please notice my comment. Im very new with vba

[@rittikasingh4699]

hi , PK: sir
can you tell me the solution for this error
RowSource = sh.Name & "!A2:C2" & last_row

[@Traveller_Mood_On]

For me also

[@baliongerewiong2194]

Thankyou Sir wonderful video, would it be possible if you could also put up a video on the Demo Attendance Management system V2 and 1, Demo Task manangement sytem v1, the demo sales purchase software on excel alone instead of connecting to Access, that would be great thanks

[@PKAnExcelExpert]

I will try to make such videos

[@baliongerewiong2194]

Please Sir If you do it will be greater thanks

[@suryaprakash7745]

Thanks very useful

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@Excell790]

Hi, I have got an error in line dsh.UsedRange.AutoFilter Application.WorksheetFunction.Match(Me.cmb8.Value, dsh.Range("1:1"), 0), TextBox13 of Filter function..... Can you help me

[@ghaivirendesingh]

Hello Sir can you upgrade this sheet.
In the update add a button by clicking on it report generated within a month attendance record of all employees . And that report is used for their salary purpose.

[@halftuber86]

HI there,
Im unable to transpose data from columns to row, is there any available code as I tried the transpose and defined the range accordingly. Basically whenever I want to export the data it should be in rows way

[@blacktooth1176]

How to fix "Run-Time error '13"
Type this mismatch." Thanks

[@shabirmmd9481]

Very good

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@vilasdhote3847]

hi sir fantastic tutorial awesome...
can you develop mental meths dictation tutorial.... thanks

[@PKAnExcelExpert]

Thanks for your valuable feedback. I will definitely try to make such video

[@vilasdhote3847]

@@PKAnExcelExpert Thanks sir for replying... I m waiting for Mental maths dictation... video... hope you will develop as soon as possible

[@Sajjadgouri786]

Supper sir ........

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@alializadeh8195]

تشکّر

[@PKAnExcelExpert]

خیلی خوش آمدید

[@jhakridos2017]

I cannot get .columnheads what is the problem here then. I am using MS Office 2013 now.

[@ThePatty7]

hi pls reply how do i add a function that enables me to put the time in and out for employees? for eg. (David time in 8am time out 8pm) in excel

[@G-GizmoMotovlog]

hi i have a question, How to create multi users to this tutorial at the same time, thank you for your feedback

[@julietavenegas5252]

hola,genial pero tu archivo que nos facilitas no habre tiene un error de depurar.
Gracias

[@mariocapinpin8366]

Sir how to fix "unable to get the match property of the worksheetfunction class" this code was in this video on attendance_ListBox matching in AttendanceDisplay, what is issue here thanks

[@ICTNuggets]

Outstanding

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@TechAndBest]

Hello sir, how important excel is? And how long excel demand will be there in the market.. Because there are many new technologies are coming in the market... For automation also nowadays excel is being used less..

[@prakashchandra5239]

Mind blowing pk

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@prakashchandra5239]

@@PKAnExcelExpert I really appreciate the efforts that you make and the outcome that you show to us.

[@hamidullahrahimi44]

Hello PK
I have problem
For default call section
Call refresh_data_list not run
Please help me what I do
Thanks

[@hassanzaid8732]

Dear Sir,
Thanks a lot for the nice information you are sharing with people. However, when I am trying to run attendance_code_listbox after writing the code it is showing "run-time error '380':?
I'm stacked and can't move further
Kindly advise
Regards
Hassan Al-Saadi

[@blacktooth1176]

If put ''' Default Call and Call Fresh_Data_List, the notice will pop up due to Run-Time Error 13: Mismatch..how to fix it? Thanks

[@kca0917]

fantastic tutorial, thanks in anyway. i'd like to know, what should i change if i want the date format be "MMM/DD/YYYY"? e.g.: Jun/04/2020, thanks again

[@PKAnExcelExpert]

Thanks for your valuable feedback. Please make the changes wherever we are using format function for date

[@kca0917]

@@PKAnExcelExpert JESUS, I FIGURED OUT WITH, THANKS AGAIN AND YOUR VIDEO SAVE MY LIFE. If IsDate(Me.REG1.Text) Then
Me.REG1.Text = Format(Me.REG1.Text, "MMM-DD-YYYY")
End If

[@kca0917]

by the way, i am not really get into, when something select in "cmb_EmployeeId" combobox, "txt_EmpName & txtSupervisor" textbox popluated automatically, any more related info or solution on this?

[@sujeetvichare5825]

@@PKAnExcelExpert So Long Video.

[@apprentissagepourtous9305]

So cool

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@RohitGupta-vy1ld]

sir please slove - RowSource = sh.Name & "!A2:C" & last_row
run-time error '380'; could not set the rowsource property. Invalid property value.

[@sakattamovie5931]

Love U Sir

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@anupyadav7707]

Sir aap Jo VBA Ka excel main bank statement Ka video bano 1 jisako hum Apne bank ke account Ka balance maintenance Kar pay apne life main use Kar ke thanks you

[@faheemahmed9380]

Sir unable to get match function property class

[@akakarun8]

Just wow!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@dwsz3589]

Good fternoon PK Sir, I have the same code like in the tutorial display in Attendance Code ListBox.But When I run the Software there is an error " Run-Time error 9". Please let me know how could I fix the error. Thaks

[@sandeepnegi607]

Sir please tell me VBA which version use for best

[@rittikasingh4699]

sir please reslove - RowSource = sh.Name & "!A2:C" & last_row
run-time error '360';
could not set the rowsource property. Invalid property value.
Overall video is very easy to understand.

[@faheemahmed9380]

Hello this problem you still solved or not

[@geetasolanki5745]

@@faheemahmed9380 hi sir calender kaise insert kare aur data add karne ke baad delete kar sakte hai kya plzz batye

[@AtanuDigital.]

Please create a small Banking management system
Please

[@puthdarakim1175]

Oh very good,

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@expertgraphics2311]

Sir you have not add delete record button in userform

[@jogeshaj1573]

Can you make mail entry and mail out system in excel

[@surendarchowdaryvattikuti3478]

What an explanation.... simple wonderful... and by the way thanks for sharing your knowledge :):) Subscribed your channel now...:):)

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@URChristiansiuuu7]

What if my company uses biometeric to capture the employee attendance, how can I connect to attendance captured by biometric to this database

[@halftuber86]

Hi there on calling the refresh data list im receiving runtime error 9 subscript out of range, what to do as coded again from the beginning. Awaiting for your feedback

[@PKAnExcelExpert]

Please check the worksheet name may be incorrect.

[@sharvari.s.vichare]

@@PKAnExcelExpert I am commenting first in RUclips of Excel Videos.
You are very expert in excel.
Awaiting for your feedback

[@DilipTiwariVlogs]

Good one, thanks!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@sujeetvichare5825]

@TheDataLabs
I watch your videos

[@SanjeetKumar-tc5gt]

Will this function is available in online excel or Ms office mobile app

[@PKAnExcelExpert]

No. I will in Desktop Application only

[@santanugupta6446]

Dear Sir,
I am unable to download calendar images and ascending or descending order images from google.
So please help me.

[@farmingmore2622]

In calendar show date command not Functioning getting an error message