Tuesday, 4 September 2012

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:

2 comments:

  1. Really very nice and usefull sir.....Thanks lot

    ReplyDelete
  2. Really very nice and usefull sir.....Thanks lot

    ReplyDelete