![display developer tab in excel 2013 display developer tab in excel 2013](https://d13ot9o61jdzpp.cloudfront.net/images/enable-developer-tab-2010.jpg)
In the Code window for the module, type the following code: Sub ShowUserForm()
![display developer tab in excel 2013 display developer tab in excel 2013](https://3.bp.blogspot.com/-gUTZW57lSu8/VHbl3c0RAmI/AAAAAAAAAOM/AnSqyTrQvDA/s1600/1%2Bclick%2Bfile.jpg)
' Set the width of the progress bar to 0. In the module, type the following code for the UserForm_Activate event: Private Sub UserForm_Activate() Note If the Properties window is not visible, click Properties Window on the View menu.Ĭhange the following properties of the Frame control to the following values:ĭraw a Label control on the Frame control.ĭouble-click the user form to open the Code window for the user form.
![display developer tab in excel 2013 display developer tab in excel 2013](https://www.chimpytech.com/wp-content/uploads/2013/11/Excel_2013_Startup.png)
#Display developer tab in excel 2013 how to
This article describes how to create a progress bar with a user form in Microsoft Excel. If you have a Microsoft Visual Basic for Applications macro that takes a long time to finish, you may want to give the user an indication that the macro is progressing correctly.