- 1 year ago
Make a VBA form appear in windows task bar
Comment
1 / 1
By default, VBA user forms in Microsoft Office applications (such as Excel, Word, etc.) do not appear in the Windows taskbar. However, you can achieve this by following these steps:
- Open the VBA editor in your Office application by pressing Alt+F11.
- In the VBA editor, select your user form from the project explorer.
- In the Properties window, locate the property named
ShowInTaskbar
. - Set the value of the
ShowInTaskbar
property toTrue
. - Save your VBA project and close the VBA editor.
With the ShowInTaskbar
property set to True
, the user form will now appear in the Windows taskbar when it is shown.
Note that this approach is specific to VBA user forms in Microsoft Office applications. If you are working with a standalone VBA application or a different development environment, the steps may vary.