×

VBA Userforms

VBA to Populate Userform Combobox from Excel Table

VBA to Populate Userform Combobox from Excel Table

What This VBA Code Does The below code will show you how to utilize an Excel Table Object to populate...

How To Build A Modern-Looking VBA Userform

How To Build A Modern-Looking VBA Userform

The Need For A Modern UI Let’s face it, VBA Userforms haven’t had much love from Microsoft over the past...

The VBA Guide For Using Userform ListBox Controls

The VBA Guide For Using Userform ListBox Controls

What Are ListBox Controls? ListBoxes are a great way to manage tables within your userform. I have used them in...

How To Set Focus To The Excel Window After Showing A Userform

How To Set Focus To The Excel Window After Showing A Userform

What This VBA Code Does There may be situations when you are using Excel Userforms where you would like the...

Limit Value Of Userform Textbox To Positive Whole Numbers With VBA

Limit Value Of Userform Textbox To Positive Whole Numbers With VBA

What This VBA Code Does I just got done updating a VBA userform requiring a textbox that would only accept...

Get Scrollbar To Appear When Launching A VBA Userform

Get Scrollbar To Appear When Launching A VBA Userform

What This VBA Code Does For some reason when you have a scrollable textbox, the scrollbar does not initially appear...

Launch VBA Userforms In Correct Window With Dual Monitors

Launch VBA Userforms In Correct Window With Dual Monitors

What This VBA Code Does Having dual monitors is one of the best ways to increase efficiency as a data...

Loop Through A Specific Control Type Within A VBA UserForm

Loop Through A Specific Control Type Within A VBA UserForm

What This VBA Code Does These VBA macro snippets will show you how to target and loop through specific controls...

Prevent Userform Textbox From Accepting Non-Numerical Values

Prevent Userform Textbox From Accepting Non-Numerical Values

What This VBA Code Does You never know what your users are going to type and that's why it is...

VBA Code To Create, Modify, & Delete Userforms

VBA Code To Create, Modify, & Delete Userforms

What This VBA Code Does  I found this concept in an Excel forum and it was attributed to an Excel...

Make Your VBA Userform Float On Screen

Make Your VBA Userform Float On Screen

What This VBA Code Does Have you ever wanted to have the ability to click off of a displayed userform...

[FREE Training] 10 Amazing Excel Efficiency Tricks. Why Don't People Know These?!

X