I love all your presentations and admire your technical skills and knowledge. Thanks so much.

@PKAnExcelExpert

3 жыл бұрын

Glad you like them!

Great, learning a lot. Thank you, PK.

@PKAnExcelExpert

4 жыл бұрын

Thanks for your valuable feedback

Thank you, you are the best brother, Just Go Ahead

Hi PK. Learned a lot from your tutorials. You explained them very clear. Keep it up .

@PKAnExcelExpert

3 жыл бұрын

Thanks for your valuable feedback

Thank you for all your videos. This one is great.

@PKAnExcelExpert

3 жыл бұрын

Thanks for your valuable feedback

This is amazing PK continue the good work that you are doing helping people learn excel and vba Thanks alot awesome many thanks for this video

@PKAnExcelExpert

4 жыл бұрын

Thanks for your valuable feedback

Great job man, I Love you, Thanks a lot for sharing a wonderful tutorial.I always enjoy your tutorial. keep it up. sty safe & healthy.

@PKAnExcelExpert

4 жыл бұрын

Thanks for your valuable feedback.

very high magic vba code to create such a file. I'm really glad to learn from it, thank you my king vba PK !

@PKAnExcelExpert

4 жыл бұрын

Thanks for your valuable feedback

Really many thanks for all your post that smart and intelligent , it's very useful in many field

@PKAnExcelExpert

3 жыл бұрын

Thanks for your valuable feedback

Your videos are really stunning and easily understand.keep Rock

@PKAnExcelExpert

3 жыл бұрын

Thanks for your valuable feedback

You are a master of userform!

@PKAnExcelExpert

4 жыл бұрын

Thanks for your valuable feedback

Thank you for this tutorial.

@PKAnExcelExpert

4 жыл бұрын

Most welcome

really outstanding tutorials...

@PKAnExcelExpert

4 жыл бұрын

Thanks for your valuable feedback

This is a wonderful tutorial. thanks a lot for hsaring this video.

@PKAnExcelExpert

3 жыл бұрын

Thanks for your valuable feedback

Thanks u are the best. 👌👌🇸🇴🇸🇴🇸🇴👍👍

@PKAnExcelExpert

4 жыл бұрын

Thanks for your valuable feedback

BRILLIANT!!!!!

@PKAnExcelExpert

4 жыл бұрын

Thanks for your valuable feedback

This issue tracker is awesome 👌👌

Fantastic work sir.. I want to make one tracker sheet similar to yours for my project😊👌👌

Thank You So Mutch, Sir.

@PKAnExcelExpert

4 жыл бұрын

Welcome

Superb!

@PKAnExcelExpert

4 жыл бұрын

Thanks Dinesh ji, for your valuable feedback. I am your big fan.

@fksoftware

3 жыл бұрын

I've learnt so much from both of you, my best teachers. PK and Dinesh. Keep up the good work Sir.

I enjoy learning from your videos! Quick question, instead of adding the MsgBox if a field isn't completed, why not just hide the submit button based on the condition of the close date field? hopefully the answer isn't too obvious, I'm learning :)

Well-Done man, Thanks a lot for sharing a wonderful tutorial.

@PKAnExcelExpert

4 жыл бұрын

Thanks for your valuable feedback

Super Helpful 👌👌👌 thanks a ton

@PKAnExcelExpert

4 жыл бұрын

My pleasure 😊

Thank you so much for an amazing tracker, PK. Can you post a session creating a Production Tracker where we could capture all the project details, Start and End time, generating utilization & efficiency reports etc... Immensely appreciate your time on sharing your knowledge globally

@PKAnExcelExpert

4 жыл бұрын

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

@saleem6r7

4 жыл бұрын

@@PKAnExcelExpert Thanks a lot. Looking forward. PK.

Great Sir.

Awesome work 👏 sir plz share something in which whatever data enter in data input , same will be reflect and show automatically in another sheet . I.e. project impact data as entered in data input tab should show in another project impact (combo box) under reports tab and under reports tab, active data should come ,not the previous entry like ID 2 , not ID 1.

Good one Mr. PK. Keep it up with innovations

@PKAnExcelExpert

4 жыл бұрын

Thanks for your valuable feedback

Great work PK, i dnt know VBA just learning,but seems very complex, can u teach us from scrach. As ur explanation is much better understandable than others in KZread. In VBA Dnt highlight in Blue while explaining, unable to see wht is in the text. u can explain without highlighting.

It is really fantastic sir

@PKAnExcelExpert

4 жыл бұрын

Thanks for your valuable feedback

Great work.

@PKAnExcelExpert

4 жыл бұрын

Thanks for your valuable feedback

Good afternoon Sir. Let me tell you first that you're the best VBA programmer in KZread in all aspects. Thank you for letting us access your applications, having access to them, it is the best way to learn. About this particular application, In the field FILTER BY, we are not able to search numbers, in your example, if I write a number in DESCRIPTION, which is the only field where I can put numbers, the listbox shows empty box. What should we add to the formula so that we could also search for numbers? Thank you.

@harryupmann

Жыл бұрын

Hi were you able to figure out why this isn't returning a number?

Awesome!

@PKAnExcelExpert

3 жыл бұрын

Glad you think so!

Great work. i have learned lot from your videos. i have userform with Listbox populated from row source (Data). i would like to filter listbox based on multiple combo box selection. do you have any tutorial or if you can help me that? thanks in advance and keep doing great work...

Hi PK sir, Your Videos are really awesome, we learn lots from you, can you also made some videos on google spreadsheet.

@PKAnExcelExpert

4 жыл бұрын

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

Hi PK. Thank you for this tutorial. Is it possible to add due date for action to be addressed and for it to go red in the listbox if it is overdue?

Hey, very good and very explicit content, this is exactly what I was looking. I was trying to play around with template and was trying to add a new field to the data entry tracker, but I'm struggling with it as I can't have to be exported to the excel file. Am I missing something here?

This is amazing PK. I will like to learn but writing the VBA codes from scratch is really difficult. What will you recommend for a starter?

Fantastic info

@PKAnExcelExpert

4 жыл бұрын

Thanks for your valuable feedback

Hi PK awesome tutorial as usual... thank you. If you could please debug, there is a problem when you enter a date, the form closes down and work does not save. thank you

Thanks so much

@PKAnExcelExpert

2 жыл бұрын

You're welcome!

thanks a lot.

@PKAnExcelExpert

4 жыл бұрын

Most welcome!

this very usefull trick.

@PKAnExcelExpert

4 жыл бұрын

Thanks for your valuable feedback

This is good for learning, do you have any presentation for EHS Incident tracker VBA

Hi PK. Thank you for the great tutorial. Can you please help on how can I fix #value! error when im using the dynamic offset with counta formula in support sheet? thank u again.

Awesome work done sir , plz suggest can we create more than 2 pages in such traker.

Keep the good work buddy

@PKAnExcelExpert

2 жыл бұрын

Thanks, will do!

thank you dear

@PKAnExcelExpert

3 жыл бұрын

Welcome

Excelent video and excelent tutorial on how to build the tracker. Now my issue is around creating a TimeStamp textbox similar with the update time wich uses the "Now" function but instead I need the time stamp text box not to change the initial time recorded on the data entry (which it does when you double click on the list box, will take the Now time instead of leaving the initial time when the data was entered) ... can you please help with this ? Thank you.

Great video

@PKAnExcelExpert

Жыл бұрын

Thanks!

This is really amazing....can this be used the same time by multiple users?

@PKAnExcelExpert

4 жыл бұрын

Thanks for your valuable feedback. It is not for multiple users, however it can be converted into a multiple users' application. I have create another video for multiple user application below is the link kzread.info/dash/bejne/ZouM3LKLf8bQfKg.html

Superb training. One criticism.....the 'Project Impact' and 'Priority' when sorted go in alphabetical order (High, Low, then Medium). I suppose one way around this is by adding a numerical value instead of text (i.e. 1 (critical), 2 (medium impact), 3 (low level impact).

@PKAnExcelExpert

3 жыл бұрын

Thanks for your valuable feedback.it is a nice idea

Hi Pk Thanks for this vdo. however, just wanted to ask you, have you ever, til now, have made any video on spreadsheet scheduler, that assists in calculating the Shrinkage %, FTE calculations, etc for the WFM planner and scheduler role? as i have seen such videos on some you tube, and did not find any on your tube channel till now. either kindly make it, or kindly share the link, if you have made it. Thank You! :-)

Amazing Video. Sir, could not follow how to display charts in userform, can you make simple video explaining in detail.

@PKAnExcelExpert

4 жыл бұрын

Thanks for your valuable feedback. Please watch below given video kzread.info/dash/bejne/lH5kt9CRc5jWdbw.html

From your project tracker I have created the user form for by requirements in this VBA I will getting error in code .rowsource property not set please advice

Hi Pk Great tutorial. I have created a tracker post watching your video. I wanted to check if the same tracker can be used by my team. The team members can view their performance only, however I'll can view consolidate data from all my team members. Thanks

@PKAnExcelExpert

Жыл бұрын

Please watch below video. I may give you some idea: kzread.info/dash/bejne/jKyZstZmZJvQkag.html

it really is the best I have tried to share it on google drive but unable to run any suggestion

Bro, if I may make a tutorial, how do I delete excel columns that don't activate? For example, suppose I have an excel 100 colom table While not all of the inputting tables are filled, well, how do you do that so that an empty table can be deleted using VBA Excel? Thank you bro, success continues to make the tutorial, bro.

This is awesome! Is there a way to have updates to a project add rows to the data table, rather than replacing it? I'd really like to use something like this, but I want to be able to have a history of the comments, as to track progress more closely. It looks like the UpdatedTime field would be the Sort field, in such a case, per project...

Nice it's Very useful, and unable to autofilter dates and number, please guide

What are the data limits in terms of how much data would this allow you to collect before it stopped working?

Just an amazing demonstration of Excel VBA potential use, Could you please suggest how to add an image file as attachment to the issue, is this possible ?

@PKAnExcelExpert

3 жыл бұрын

Thanks for your valuable feedback. Please watch below given video to learn how to add an image file as attachment- kzread.info/dash/bejne/a3qE3MaEosStXcY.html

@PradeepPatil-pp

3 жыл бұрын

@@PKAnExcelExpert Thanks PK for reply, yes I saw this your video, but it sounds only to show the photo, I was thinking to have list box in issue tracker where while creating issue one can browse one or more issue related files like logs as supporting document and this attachment could be txt or jpeg/png and when we revisit the issue one can view inside this listbox already attached files to the issue and double-click to save as or view it. Thanks again for your time and efforts.

Wonderful

@PKAnExcelExpert

3 жыл бұрын

Thanks for your valuable feedback

Good day PK! Many thanks for your very informative and detailed tutorial. May I know what the issue might be regarding the Filter by part? When I try to sort by number like ID, it doesn't return anything in list box. But text like name is working

@harryupmann

Жыл бұрын

Hi did you ever figure it out, I am running into the same issue

متشکّرم

@PKAnExcelExpert

2 жыл бұрын

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

Hi Dear PK, Thankyou for such a good information. Date picker is not working, if I open the form from command button and without VB Editor on. The issue is, it opens the calendar form, but upon clicking on date, it simply clears are the fields, form exists and no date is selected. What could be the cause? I am using Windows 10 Office 365 on 64bit system.

Thx PK. , Really very useful video , but i have a problem in listbox .rowsource when i open the workbook individual it works good but when i open another excel workbook it give me error run-time error 380 could not set rowsource property. Invalid property value . So the problem here is to make the workbook to be focused to eliminate this error . How to do this?? . Thanks again

This is superb, Sir can i use this template for my project? can i email you for additional help?

Sir is it possible to link data from local pc excel sheet to server excel sheet through coading

Great work, kudos, can you please do a tutorial of creating E-voting in #Excel

@PKAnExcelExpert

4 жыл бұрын

Great suggestion! I will try.. Thanks

Very great job! I have just seen an issue with calendar form. When selecting dates in July 2021, it refers to June. Other months are okay. Can you please help to fix it? I really like your date picker ;)

@mazensen

3 жыл бұрын

Finally found it was coming because of french language. In french June and July begin with same 3 first letters ("Juin" and "Juillet"). It would be better taking that into consideration for date consolidation 😊

I have a one question .how to create a vba file in different user login Id in different system please explain... 🙏🙏🙏

You are master in excel. Excellent bro can we use this template?

@PKAnExcelExpert

3 жыл бұрын

Thanks for your valuable feedback. Yes, you can download it from the link given videos description box or visit our website Www.pk-anexcelexpert.com

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

Nice,

@PKAnExcelExpert

2 жыл бұрын

Thank you! Cheers!

Hi, I am stuck at refresh listbox, getting an error as Unable to get the match property of the Worksheet function class

very good

@PKAnExcelExpert

4 жыл бұрын

Thanks for your valuable feedback

What is the VBA code to high light the list box data based on conditions

Thanks!Hii at 24:06 in New code where and what is Sub Refresh Dropdown list () ??

sir how delete row data but not entirely (full row ).it means if data started A:X, I WANT TO DELETE A:O, WITH VBA CODE,,,,,,,PLEASE REPLY

Hi sir thank q very much for great efforts. Sir I have a small question to u In Account Receivable payment there are multiple payments against single invoice and multiple invoices and multiple payments for same customer From userform how can v place the sum of partial payment to a specific invoice ? Can u please help us thank q

Hello, thank you for the awesome video. I have downloaded a calendar from your web site but I would like to know how to add it in the visual form?

@PKAnExcelExpert

Жыл бұрын

Please watche the below videos to learn more about the Calendar Control : kzread.info/dash/bejne/l2xtsqh8orC7lqw.html kzread.info/dash/bejne/gZicssh9ZLXUhrQ.html kzread.info/dash/bejne/hptpktN6ZtTae6g.html

@nootn_drawing7386

Жыл бұрын

@@PKAnExcelExpert Thank you so much. 😊

@nootn_drawing7386

Жыл бұрын

Hi Sir, I tried to copy you but it’s stuck at the process displays the data on the list box . It said “run time error ‘1004’: Unable to get the match property of the WorksheetFunction class. Even, I created a new user form but it still stuck at the same process. Could you please advise.🙏

Boss, this is very useful, thank you very much, and how to export separate sheets by particular criteria in the one book all time and without duplication, please give me code as vedio, please

@TheNewLifeTech

4 жыл бұрын

Unable to filter number and dates, please help me to solve

Hello PK, nice project. I have download you project to study with. I have one question. I'm not able to see the sheets in order to change same list. How can i made it? Many thanks

@PKAnExcelExpert

3 жыл бұрын

Thanks for your valuable feedback. You can unhide the sheets using Alt+O+H+U shortcut key.

Any data change in tally excel day book BHI change automatically

Super..... Tool. Thank you for making this video. Sir please do small project on vlookup for extracting data for multiple columns from multiple files in folder.

@datacleaningchallenge2029

4 жыл бұрын

i can help you do that

Friend, any one of you having this download file. I'm trying to purchase but I could not

Dear sir data transfer userform to table1 Add automatic vba

How to use macro sheet working in mobile

Very good. If you write the code it will be excellent and long talking.

can you give me a piece of code in vba with access database to reset serial number to 1 when the date changes

Hi PK where ca I get the VB code from? thanks

Have you done any training for vba coaching.

@PKAnExcelExpert

4 жыл бұрын

You can watch our VBA Tutorial playlist

PK I am your sikshak, you my guru, excel is my hobby, very amateur. Well, how do I get your form code to adapt my forms suitable for me?

Crate Utomatic reorder list plz bro

Dear Sir, I have list of employee unik ID as below format Year Month Employees WWID Employees Funtion Observation In the sheet employee raise their observation, in some month same employee report multipal observation. I wanted to count unik Employee WWID for salected Year, Month and employee funtion. note that if same employee raise multipal obeservation in same month it should count only one time. Request to you pls made a viedo for calculate same by using formula. Thanks!!

Hi PK Sir, Can you make a VBA Userfrom with upload attachments & Data saved to another file and attachment in specific folder with hyperlink in database file.

@PKAnExcelExpert

4 жыл бұрын

I will try to make such video

@DineshKalel

4 жыл бұрын

@@PKAnExcelExpert Thanks for prompt response.🙏

@stephenbrincat7124

4 жыл бұрын

@@DineshKalel Thanks PK, would it be possible to save such data in a mysql database?

Not Able to run Set sh = ThisWork.Sheets("List") facing bug in this section. Please Help

@drakeallen8890

3 жыл бұрын

Make sure to include the "book" after work. should read as Set sh = ThisWorkbook.Sheets("List")

hi. have you got a payments manager and tracker?

@PKAnExcelExpert

Жыл бұрын

Great suggestion! I will try to create a video on this topic.

Sir you are amazing. At 47:58 list index value is still 0 is we don't select any record in the listbox Or if we select 1 record, still listindex value is zero. The first if condition for msgbox is not working. If we don't have select any record in the listbox still it give msg "deleted successfully" Please make a new formula for this. My brain isn't working on this problem

Hello Dear, I am getting error 401, please suggest how i can fix it?