How to create a DIGITAL CLOCK in Excel with visual Basic language ~ Ssbtechcomputer

Ssbtechcomputer

Welcome to the world of technology and computers! Our blog is your one-stop destination for all things related to computers, technology, and computer courses. Whether you're a tech enthusiast, a student looking to enhance your skills, or a professional seeking the latest updates in the industry, we've got you covered.

How to create a DIGITAL CLOCK in Excel with visual Basic language

 DIGITAL CLOCK in Excel



1. Open Excel.

2. Select and merge the cells where you want to create digital clock.

3. Use a formula for insert time =NOW()

4. Now move on the numbers format by Ctrl+1

5. Select the TIME from number group & pick HH:MM:SS format of time.

6. Change the font face into DIGIFACE.

7. Press Alt+F11 to move on Visual basic plateform (VB).

8. Click on Insert.

9. Select the Module

10. Type this code.

11. Press F5 to run your code.

12. Move on excel here is your digital clock.


Whatsapp      Telegram     FB Page     Twitter      Instragram       Our Book
Previous
Next Post »