How to Create Digital Clock in Microsoft Excel | Digital Clock in Excel VBA

[@Entertainment69134]

My knowledge increase watch your video sir thank you alots ❤

[@TanveerAhmed-hv4gn]

Good Job Keep Going on

[@Sanjay_Banik]

Can we change subtotal figure as per decimal. I have a master data. Where a project have 3 decimal should reflect. And for rest decimal not required. If I click Slicer, it shows either decimal or without decimal.

[@AjayKumar-n5g8h]

Nice video

[@kreeds1595]

Nicely explained. Keep it up.

[@shahaaqib6904]

Sir is it predetermined information you have selected on a digital clock in a developer tab for everyone except for a range?let me confirm please

[@ShivPrajapati]

I am scanning everyday some barcodes, when we are scanning row 1-10 in column A, then i need curser automatically in Column B. But its continuous going down 11,12,13 like that

[@R.R.P.5559]

Very good 🎉

[@StudySpan]

Thank you so much. Stay tuned for latest videos

[@galcymdepuhu8192]

The best❤

[@akashpayelkar8806]

Sir same bana Diya thank you sir

[@StudySpan]

You are mostly welcome. Stay tuned for latest videos

[@pratiksha.mishra]

Thank you.

[@venkatachalam1996]

Thanks lot🎉🎉

[@JiteshMani-q9u]

Wonderful

[@rajupasunuripasunuri8455]

Thank you

[@ShivPrajapati]

Hello sir, i asked to many channels, but no one answered. Please help me. I need a little help

[@faizpatel6581]

Good

[@StudySpan]

Thank you so much. Stay tuned for latest videos

[@israkhan63]

Nice

[@NitishPrajapati26]

Bhai sab se sahi tariya ye hai =Now()+1

[@radheybhaiya515]

I did Step To Step But & Code Also Type Same to Same .....But Clock is Not Working Automatically.........
Sir Version Kon Sa hai Aapka 🤔🤔🤔

[@StudySpan]

2013

[@THE.RIGHT.WAY.OF.TRADING]

thumsup

[@muhammadayaz7288]

If I close the excel
And open it again then not working

[@sannnu107]

Thanks Brother

[@tvmi5495]

Not coming showing error as compile error invalid use of property

[@nishantmehar5943]

Date ka bhi bana do sir

[@msi________2760]

the clock will start automatically when the workbook is opened. Just paste the updated code into a new module, and the clock will start running as soon as the workbook is opened.

[@nirajthakor9748]

It stops when we close the sheet??

[@msi________2760]

See my above Code

[@msi________2760]

the clock will start automatically when the workbook is opened. Just paste the updated code into a new module, and the clock will start running as soon as the workbook is opened.

[@nirajthakor9748]

​@@msi________2760Where is it?

[@chatorachef57]

After sheet is closed and open time stop running

[@sweetmask1690]

The time is not exact. How to solve this? Its 4pm in computer but in excel its 1am

[@thantzinmaung3391]

after save and close, not running the clock reopen sheet. Why? Please explain.

[@sprabhatakisan6854]

C++ ki video dijiye please sir help me

[@StudySpan]

Ok... I'll try

[@himalayanpowerpartnerltd.7274]

It runs in every other sheet automatically. How to run in only first sheet?

[@maxdoescatsim]

Go to basic visual and find clock and stop and close the basic visual and your done

[@Miss__Mamuni_]

Only C2 cell me hota hai aur koi cell me nhi

[@rambabubhai]

Sir error bta rha ha

[@StudySpan]

Requesting you kindly watch out the full video carefully, then apply the VBA code

[@rambabubhai]

Sir pura full video dekhe ha

[@rambabubhai]

Sab kuchh same to same tabhi bhi nhi ho rha ha

[@msi________2760]

Private Sub Workbook_Open()
StartClock
End Sub
Sub UpdateClock()
' Update the clock display every second
Range("A1").Value = Now
Application.OnTime Now + TimeValue("00:00:01"), "UpdateClock"
End Sub
Sub StartClock()
' Start the clock
UpdateClock
End Sub
Sub StopClock()
' Stop the clock
On Error Resume Next
Application.OnTime Now + TimeValue("00:00:01"), "UpdateClock", , False
End Sub

[@prabir662]

Good

[@msi________2760]

the clock will start automatically when the workbook is opened. Just paste the updated code into a new module, and the clock will start running as soon as the workbook is opened.