We use the IsMac if conditional code so that users running Excel on Mac can also use this macro code without crashing.Next, we will display the progress bar by entering this macro code in the open window.We will go back to the userform, right-click and select View code.
We will change the special effect property to 3-fmSpecialEffectRaisedįigure 18 – Using a VBA update status bar Add Macro code to Userform.Change the name of the property to ProgressIndicator.We will select another Label and insert into the first label.We will insert a second Label directly inside the first label. Next, we will change special effect property to 2-FmspecialEffectSunken.Next, we will erase all content in the Caption field and Change the name of our Frame to ProgressFrame.To add properties to the frame control, we will right click on the frame control and select properties.Next, we will drag frame control on the Userform.įigure 12 – Making an excel VBA status bar.We will add a frame control to the Userformįigure 11 – Making a VBA update status bar We will also set the width of this label to 162.We will also set the height at 50 and set the Caption as an empty string. We will change the name of Label 1 to CapLabel.
ISRO CS Syllabus for Scientist/Engineer Exam.ISRO CS Original Papers and Official Keys.GATE CS Original Papers and Official Keys.