MI HAYATUL ISLAM: Userform

Tuesday, September 4, 2012

VBA Excel: Userform > Set Parent

The below code will be used to set the UserForm UF as a child of (1) the Application, (2) the Excel ActiveWindow, or (3) no parent. Returns TRUE if successful

VBA Excel: Userform > Opaque / Transparent

The below code will be used to set the Opaque / Transparency Level of the userform. Usually the VBA Userform doesn't have this feature, but through API functions we can do this.

See Declaration Library post to understand and get the API function declarations.

VBA Excel: Userform > Resize Property

The below code will be used to make the Userform resizable . Usually the VBA Userform doesn't have this feature, but through API functions we can do this.

See Declaration Library post to understand and get the API function declarations.

VBA Excel: Userform > Title bar

The below code will be used to customize the Title Bar in the userform. Usually the VBA Userform doesn't have this feature, but through API functions we can play with the Title Bar in the userform.

See Declaration Library post to understand and get the API function declarations.

VBA Excel: Userform > Close Button

The below code will be used to customize the Close button in the userform. Usually the VBA Userform doesn't have this feature, but through API functions we can play with the Close button in the userform.

See Declaration Library post to understand and get the API function declarations.

VBA Excel: Userform > Minimize Button

The below code will be used to customize the Minimize button in the userform. Usually the VBA Userform doesn't have this feature, but through API functions we can enable the minimize button in the userform.

See Declaration Library post to understand and get the API function declarations.

VBA Excel: Userform > Maximize Button

The below code will be used to customize the Maximize button in the userform. Usually the VBA Userform doesn't have this feature, but through API functions we can enable the maximize button in the userform.

See Declaration Library post to understand and get the API function declarations.

VBA Excel: Userform Customization - Declaration Library

In the upcoming tutorials I am going to post 'free source codes' to Customize the VBA Userform, To do the below customization we need to do the declaration. The below code is common for all the below operations.

* Enabling/disabling Close [X] button
* Enabling/disabling Minimize [-]& Maximize button
* Show/hide Userform 'Title' bar
* Set Userform Opaque / Transparency
* Enable/Disable Userform's Resizable property

This is the sample exercise form snapshot and the code entered in the Userform-Module.

Userform Code: