How To Countdown in the status bar using VBA in Microsoft Excel?
Tags: tocountdowninthestat, vbamacros
Published: 2021-10-19 05:08:39

---
title: How To Countdown in the status bar using VBA in Microsoft Excel?
published: true
date: 2021-10-18 07:25:00 UTC
tags: ToCountdownInTheStat,VBAMacros
canonical_url: https://geekexcel.com/how-to-countdown-in-the-status-bar-using-vba-in-microsoft-excel/
---

In this article, we will guide you on how to  **countdown in the Status Bar using VBA ** in Microsoft Excel. Let’s get them below!! Get an official version of MS Excel from the following link: **[https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)**

## Example

- Firstly, in the Excel Worksheet, you have to go to the  **Developer Tab.**
- Then, you need to ** ** select the  **Visual Basic**  option under the  **Code**  section.

![Select Visual Basic](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/09/Select-Visual-Basic-9-1024x180.png)<figcaption>Select Visual Basic</figcaption>

- Now, you have to  **copy and paste the code**  given below.

```
Sub CountDown()
   Dim intCounter As Integer
   Dim bln As Boolean
   bln = Application.DisplayStatusBar
   Application.DisplayStatusBar = True
   For intCounter = 30 To 1 Step -1
      Application.StatusBar = intCounter & " Seconds..."
      Application.Wait Now + TimeSerial(0, 0, 1)
   Next intCounter
   Application.StatusBar = False
   Application.DisplayStatusBar = bln
End Sub

```

- After that, you need to  **save the code**  by selecting it and then  **close the window**.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/10/Save-the-Code-52.png)<figcaption>Save the Code</figcaption>

- Again, you have to go to the  **Excel Spreadsheet** , and click on the  **Developer Tab**.
- Then, you need to choose the  **Macros option**  in the Code section.

![Choose Macro option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/09/Choose-Macro-option-11-1024x184.png)<figcaption>Choose Macro option</figcaption>

- Now, you have to make sure that your  **macro name is selected**  and click the  **Run ** button.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/10/Run-the-Code-44.png)<figcaption>Run the Code</figcaption>

- Finally, after running the macro, you will get **output** in Microsoft Excel.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/10/Output-25.png)<figcaption>Output</figcaption>

## A Short Closure

Here, we have explained the step-by-step procedure on how to  **countdown in the Status Bar** using VBA in Microsoft Excel. Make use of this. Please share your worthwhile  **feedback**  in the below  **comment**  section. To learn more, check out our website **[Geek Excel](https://geekexcel.com/)!!**

**Continue Reading:**

- **[Show or Hide Ribbon, Formula Bar, and Status Bar in Excel 365!!](https://geekexcel.com/show-or-hide-ribbon-formula-bar-and-status-bar-in-excel-365/)**
- **[Status Bar Options in Excel – Customize and Use Status Bar in Excel 365](https://geekexcel.com/status-bar-options-in-excel-customize-and-use-status-bar-in-excel-365/)**
- **[Display A Message On The Excel Status Bar Using VBA in Excel](https://geekexcel.com/how-to-display-a-message-on-the-excel-status-bar-using-vba-in-excel/)**
- **[How To Insert the path where the Workbook is saved to the title bar using VBA?](https://geekexcel.com/how-to-insert-the-path-where-the-workbook-is-saved-to-the-title-bar-using-vba/)**
- **[How to Use Formula Bar for Various Purpose in Excel 365](https://geekexcel.com/how-to-use-formula-bar-for-various-purpose-in-excel-365/)**