Hey, This is Puneet back again and this video is going to be

interesting in so many ways. So we are gonna learn how we can use a VBA

code to hide or unhide the status bar, or how we can show

a message on the status bar. So, first of all, I'm gonna open the Developer Tab and I'm gonna

Click on the Visual Basic Editor to open it and then I'm gonna insert a new model

to use and from here I'm gonna start the code

[typing code]

So the first thing is to use the

application object and as well as you press

a dot.It gives you a list to select the properties so you need to select

Display Status Bar and here you

can use two different values False and True. So I'm gonna use False

here. Now this line of code tells VBA to

Hide the Status Bar. So application displays status bar equals

False and now if I run this code it simply hides

the Status Bar and now if I want status bar back I'm gonna use

True here. Application displays status bar equals True

that means to show the Status Bar and I fell on this code

it simply gives me Status Bar back. Alright!

So from here I'm gonna change the property

.Status Bar. Now I can you this property to

show a message (a custom message) on the Status Bar so I'm gonna use

equals again and then a message that I want to show

[typing code]

Alright! so I'm gonna run this code

as soon as I run this code it simply shows that message

which has been specified in the code on the Status Bar. Now, here is one thing that

you need to take care that when you show a message on the Status Bar using a VBA code it

will stay there untill or unless you clear that message so

to clear that message we need to run this code again but with the Blank Value.

So, Application.StatusBar equals a Blank Value

and when I run this code it simply gives me

the default status bar back

or you can also use False to come back to the default Status Bar if you already have

a message on that you can simply use False. Just like that.

Now, let's see an example where we can show a progress message on the

Status Bar. A progress message of a loop so for this I'm gonna

use a code. Now, in this code, we have a loop that will run from

1 to 10,000 times and show a progress message on the Status Bar. So, let's

understand this code line by line so in the first line here I'm using a

variable to store the count of the loop and

in the second line I'm using, actually, I'm starting a loop that will

loop from count 1 to 10,000 say in this line I'm using again

that Application.StatusBar and here we have a message that will show

the progress so it says x of 10,000 so basically x is the counter of the

loop and the format x/10,000 percent so this

the part will show the percentage of the progress and then a

closing loop and here I'm using those events to not to hang the

excel application so basically when you run a loop excel simply a freeze

everything untill that loop stop and here I'm using

the Application.StatusBar = False to clear that message in the end.

So make sure to have a look on the Status Bar because this progress

message will be there for a few seconds.

Now as you can see that progress that loop is running.

Typing

It will take quite a few seconds

Alright! wait 75%

85%, 95% and 100.

Now, here you need to note down the two most important points

that you always need to use Application object before using

Status Bar or display Status Bar property and you always need to

clear the message from the Status Bar using a code that means you

need to use Status Bar = False or a Blank Value to

clear the message. Hey, thanks for watching

this video and I hope you found this VBA trick useful and

make sure to subscribe to this channel because I will be coming out with lot of cool

and helpful VBA Tutorials in the coming weeks. So, make sure to hit

Subscribe Button and Like this Video and I will see you next week

:)