Create digital clock that updates time in real time using a UserForm

แชร์
ฝัง
  • เผยแพร่เมื่อ 11 ก.ย. 2024
  • How to create a digital clock on a calendar?
    How to update time in real-time automatically?
    How to run macro without stopping users from editing?
    Countdown timer on UserForm 👉 • Countdown timer with H...
    Excel & VBA discussion public group 👉 / 486402069483674
    Welcome to join and feel free to raise/ask questions (if any) or share Excel tricks 🤗
    #excel #vba

ความคิดเห็น • 2

  • @muhammadkausar2842
    @muhammadkausar2842 2 หลายเดือนก่อน +1

    Exactly what i want for my calendar, but if Code is running , it effect the performance of the system, is their any other method
    I also tried Application.OnTime
    Which is also work, but if their is any other efficient method you know then please share with us

    • @ahsing_excel_VBA
      @ahsing_excel_VBA  2 หลายเดือนก่อน

      Hello. 🤔 Since this is specifically for the calendar, which allows users to select and insert a date instead of typing it manually, I expect users to select a date before proceeding to the next task.
      If you want to run multiple macros at the same time, I usually open the workbooks as new instances of Excel so that they can run simultaneously. Not sure if this is what you were looking for.
      Thanks for watching. Wishing you a wonderful day.