Traditional Culture Encyclopedia - The 24 Solar Terms - How to use excel to make a dynamic countdown accurate to seconds, such as 3 days 15 hours, 20 minutes and 7 seconds?
How to use excel to make a dynamic countdown accurate to seconds, such as 3 days 15 hours, 20 minutes and 7 seconds?
2. In the Excel operation window, press Alt+F 1 1 to pop up the VBA window, and then perform the following menu operation: Insert → Module.
3. The code input window shown below pops up.
4. After the above code is successfully entered, right-click "ThisWorkbook" on the left side of the window and select "View Code", as shown below.
5. Finally, close the vba window, return to Excel to save the file, then close Excel, and then open the Excel file, and the effect will come out.
Precautions:
Although Excel provides a lot of user interface functions, it still retains the functions of the first spreadsheet software VisiCalc: rows and columns form cells, and data, formulas related to data or absolute references to other cells are stored in cells.
- Previous article:Middle-class lesson plans
- Next article:What does dogwood look like during the Dragon Boat Festival?
- Related articles
- A poem describing camellia
- What's the date of 1973 in beginning of winter?
- Bloom, if you don't come, I'll be old-
- Gao Yuanyuan's fragmented time, what is her personality charm?
- How to press reset when the tire pressure light is on?
- Catalogue of Works of Jitong Selected Books
- Rui Shuang 125-2f always can't add the accelerator, and always flushes the engine during exercise.
- What are the traditional festivals in China? What month and date are they?
- Is there a custom of sweeping graves at the vernal equinox in Guangxi?
- Copy of Cp summer solar terms