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:
Really very nice and usefull sir.....Thanks lot
ReplyDeleteReally very nice and usefull sir.....Thanks lot
ReplyDelete