Innovation: Digital Clock in Excel (VBA+Autoshapes)

[@TommyBo42]

Typing this on my phone, sorry for not writing everything like variable declarations and breaking the infinite while loop. Create an array variable for each digit, with true/false for each segment. Leave element 0 as null: dig_0=array(,true,true,true,false,true,true,true) Etc. Then, create an array of those digit arrays: dig_arr=array(dig_0,dig_1,dig_2,etc) To run it: Do while 1 digT= format(now,"hhmmss") For i=1 to 6 shName = mid(digT,i,1) For j=1 to 7 Set shp=ws.shapes (format((i-1)*7+j,0)) shp.visible=dig_arr(shName)(j) Next j Next i DoEvents Application.wait (now+#12:00:01 am#) Loop

[@ayyolcu]

Here the real excel expert

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@miguelprietosanchez5883]

Greetings from Venezuela wishing you are well PK I am a faithful follower of your teaching you are the best but with the digital clock I am missing a bit of the macro that is not seen in the video and I cannot open the practice book if you could send me the Macros complete I would appreciate it very muchthank you that you are well

[@hoanglieus2ndchannel39]

Thank you for the video!

[@PKAnExcelExpert]

Most welcome

[@RamakrishnanRukmini]

Great work. Keep it up.cheers.

[@PKAnExcelExpert]

Thank you! Cheers!

[@ChrideOfficial92]

Thanks Mr PK for this amazing work, i wish you to work for dynamic clock picker as you have done dynamic calendar in userform

[@siddheshsawant2818]

Hats off to your creative, very nice

[@PKAnExcelExpert]

Thanks for your valuable feedback. Please share it with your friends and colleagues

[@Saatt79]

Awesome Invention 👏👏👏👏👏

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@sumank2190]

Excellent ...Keep going on...

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@pramodml2725]

Hi Sir,i want to create employee working hours in day & also the time should be connect to system time and date, if employee log off the system ideal time also have to calculate for break hours, (like 1st break, 2nd break, 3rd break etc) can you plz help me with this?

[@joses.pacheco3069]

You do the fun work. Very good. Sensational! Leave your comment and your like.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@vilasdhote3847]

sir i liked your video... thanks for sharing valuable information with us.

[@afzaalahmed9565]

Very interesting

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@anilbabbar2290]

Excellent work! Please advise me on how to run this on Excel version 16.35 on Mac. I downloaded your file, the digits are frozen. I invariably come across such issues on Excel for Mac. Irrespective of my problem, you have done a great job.

[@esbi1124]

Hello, really good, man.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@info2satish]

Great PK!!👍

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@svijayiitk]

Genius and creative! Thank you for this video! Instant Sub

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@SyedMuzammilMahasanShahi]

Thank you. This is beautiful

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@sulthansvm6834]

Hello sir I want to learn odbc connection from Excel how create Microsoft query and how to do connection without SQL .... kindly we are using links ... please do need full.

[@raghibali938]

Very good

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@Kidskashow]

Salute dear.

[@PKAnExcelExpert]

Thanks for your valuable feedback.

[@sandeepkumar-cx4or]

Awsome sir you are great

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@kareemrasheedbabatunde9026]

Thank you guy, I really appreciate you

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@Alibabachalise]

Sir thank you for good lesson. I could not be succeeded if there were no download file. Many thanks

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@anbaabdellah8022]

Top

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@jackhacker348]

This is the guy who you go to for help with your homework

[@iwankurniawan9666]

Genius !

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@indrac6085]

Awsome my friends.. good to try.. thank you..😊

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@rachid18setexam]

Bravo 👍________[]✓[]

[@PKAnExcelExpert]

Thanks

[@mfneyaz]

amazing!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@prabhathsandaruwan4030]

Hi PK. I also watched your most of videos & I wish your good luck !!! I have a problem related change time automatically in worksheet Currently I'm using following code with =now() function in cell Public Sub Recalculate() Calculate Application.OnTime earliesttime:=Now + TimeValue("00:00:01"), _ procedure:="Recalculate" End Sub I want to change this code to run real time in sheet once open excel sheet without button click... I mean how this time funtioning time with second automatically after open the excel sheet ?

[@sulthansvm6834]

For export the data

[@teckhindi8291]

Namaste sir ji, Sir main chahta hu k, ek challan no. Daalte hi....Usme likhi hue sabhi item alag alag row mai number wise show ho jaaye.... Vlookup lagane se ek baar mai ek hi item show hota h, company data fill karna h mujhe.... Mera matlab h jese ek company mai baar baar challan per goods jaati h... Ab excel mai koi esa table banaya jaaye k usme challan no. Waali cell mai no. Dala jaaye or us challan mai joh joh item likhe ho voh line wise show ho jaaye..... Plzzz sir....Batana jaroor I am waiting.........

[@ChrideOfficial92]

Can you make the dynamic clock picker in userform please, it was challenged me i ask for help

[@MohAboAbdo]

Thanks ... Thanks ... Thanks

[@PKAnExcelExpert]

Thanks for watching

[@pankajgi]

Is there any way to blink or flash any value in excel?

[@humanrights2531]

Hi Sir. We see you are interested in Excel deep learnin. Watch our videos. If you like pls subscribe and share. We,ll teach you everything

[@humanrights2531]

kzbin.info/www/bejne/foq7mmiPr75ghq8

[@vimukthilakshann6996]

elama

[@paraschaurs]

What does that 15, 36 means

[@ChrideOfficial92]

Good work and Amazing template you have created, so now i wish you to create a time picker in userform as you have done calendar. it will be helpful. thank you for your work

[@VIREN007]

sir, How can type two different fonts in one cell. Any shortcut key or VBA.

[@GauravSharma-us9ec]

thank you...so much sir

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@abdulquddus8089]

Thank you sir..

[@PKAnExcelExpert]

Thanks for watching

[@pramodml2725]

Please upload some different nd innovative videos.....

[@svijayiitk]

Offensive comment -_-

[@JoseLopez-yv8rd]

Hello, when i want to run after finishing module 2. i get and error. Can you please help me

[@PKAnExcelExpert]

I have given the download link in video's discretion box. Please download this excel file from there and match your code with mine. I hope it will help you.

[@svijayiitk]

@@PKAnExcelExpert Description box*

[@alializadeh8195]

Thanx

[@PKAnExcelExpert]

Welcome

[@ashvanikumar8854]

can you share me module

[@mohammadhoseinbahmani6567]

how can I get VBA codes?

[@allabouttruckin2635]

Hello Sir. I am new in vba i want to make a restaurant POS in which i can take orders from table and take away and delivery orders also. And keep all the reports also. Please share any ideas you have thanks in advance

[@robertkamanga1551]

Greetings. How did this project go.

[@Valandor_Celestial_Warlock]

Three ads in less than 9 minutes. That's gotta be some kind of record.

[@bidaultmarc]

J'ADORE, mais je ne parle pas anglais, je n'ai rien compris, dommage pour moi.

[@PKAnExcelExpert]

Vous pouvez le télécharger à partir du lien indiqué dans la boîte de description de la vidéo. Ce sera facile à comprendre dans le fichier avec le code.

[@FedericoSpada13]

Why don't you simply install a font that make numbers look like that and print time as normal text?? This is overcomplicated for a task that is easily solvable...

[@roshangeorgenetwork64]

Sir code please 😊

[@tranminh2010]

so fast