How to Customize Controls in Excel VBA

How to Customize Controls in Excel VBA

In this video, I show you how you can customize controls on UserForms.

If a control does not have the behavior you like then you can easily add it. The best part is that once you have created this behavior you can apply it to any control you wish with just a couple of lines of code.

The see the benefits of customizing controls I will show you a real-world example that I created and has been employed by hundreds of VBA users.

#excelvba #VBACustomEvents #VBAWithEvents #WithEvents #UserFormControls

SUBSCRIBE TO THE CHANNEL: https://bit.ly/36hpTCY

Learn how to build Excel VBA Applications the right way using best practices and proven techniques:
The Excel VBA Handbook Course(https://TheExcelVBAHandbook.com)

DOWNLOAD the Code for this video: https://shorturl.at/pN179
(If there is a problem with the download page make sure to turn off any AdBlockers that are running)

Free Excel VBA Resources
Excel VBA Articles (https://excelmacromastery.com/vba-art...)

Useful VBA Shortcut Keys
========================

Debugging:
Compile the code: Alt + D + L OR Alt + D + Enter
Run the code from the current sub: F5
Step into the code line by line: F8
Add a breakpoint to pause the code: F9(or click left margin)

Windows:
View the Immediate Window: Ctrl + G
View the Watch Window: Alt + V + H
View the Properties Window: F4
Switch between Excel and the VBA Editor: Alt + F11
View the Project Explorer Window: Ctrl + R

Writing Code:
Search keyword under cursor: Ctrl + F3
Search the word last searched for: F3
Auto complete word: Ctrl + Space
Get the definition of the item under the cursor: Shift + F2
Go to the last cursor position: Ctrl + Shift + F2
Get the current region on a worksheet: Ctrl + Shift + 8(or Ctrl + *)
To move lines of code to the right(Indent): Tab
To move lines of code to the left(Outdent): Shift + Tab
Delete a Line: Ctrl + Y(note: this clears the clipboard)