![developer tab excel 2007 developer tab excel 2007](https://www.passfab.com/images/topics/excel/protect-worksheet.jpg)
![developer tab excel 2007 developer tab excel 2007](https://support.content.office.net/en-us/media/4e046466-29e7-4d71-9d59-cda441070ef9.png)
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.
#Developer tab excel 2007 how to#
This article describes how to create a progress bar with a user form in Microsoft Excel.
![developer tab excel 2007 developer tab excel 2007](https://i.ytimg.com/vi/SbC63MLxXCE/maxresdefault.jpg)
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.