Have Questions? 
help@excelvbaisfun.com
Excel Ninja Pro
All Access

Recent Posts

Check out the latest articles on making your life more fun with Excel VBA!
How To Prompt For A File In Excel VBA

If you need to Prompt to open a file in Excel VBA, check out the below code snippet. Please leave us a comment below if you have questions or comments and share this page if you think it can help others! You can now manipulate the other workbook, because we told Excel that the other […]

Read More
Enter Textbox Date In Excel Without The Slash - Type Only The Numbers

Sometimes you might have a client or you yourself may have the need for a date text box where the user wants to type in only the numerals for a date, and none of the slashes. The first thing we need to do is create a user form with a single text box in it. […]

Read More
Changing A Cell's Value In Excel VBA (Range Object Method)

[et_pb_section bb_built="1" next_background_color="#000000"][et_pb_row][et_pb_column type="4_4"][et_pb_text _builder_version="3.0.105" background_layout="light"] One of the most foundational things to learn about when using Excel VBA is how to change a cell value, so that you deal with with this blog post. On the most basic level, all you have to do is open up the Visual Basic editor in Excel by […]

Read More
6 Oclock and 12 Pm Don't Appear Correctly on Userform

[et_pb_section bb_built="1" _builder_version="3.0.105" next_background_color="#000000"][et_pb_row _builder_version="3.0.47" background_size="initial" background_position="top_left" background_repeat="repeat"][et_pb_column type="4_4"][et_pb_text _builder_version="3.0.47" background_size="initial" background_position="top_left" background_repeat="repeat"] Sometimes using a text box on a user form or on a worksheet doesn't work exactly the way we think it should. This is especially true when were working with dates and times straight from a worksheet. The problem we faced when […]

Read More
Loop Through Multiple Files in a Folder and Scrape Data From Each

[et_pb_section fb_built="1" _builder_version="3.0.47"][et_pb_row _builder_version="3.0.47" background_size="initial" background_position="top_left" background_repeat="repeat"][et_pb_column type="4_4" _builder_version="3.0.47" parallax="off" parallax_method="on"][et_pb_text _builder_version="3.0.47" background_size="initial" background_position="top_left" background_repeat="repeat"]Sometimes using loops with the fileSystemObject in Visual Basic isn't the most intuitive thing to use, but in this article I want to show you some basic things you can do with it. Without getting too technical, the purpose of this […]

Read More
Excel VBA Format Textbox Hours and Minutes for Start Time and End Time

[et_pb_section bb_built="1" next_background_color="#000000"][et_pb_row][et_pb_column type="4_4"][et_pb_text] Recently, I was asked how to format Textboxes as Hours and Minutes, like a Start Time and End Time, here's a quick video tip I replied with. Hope you enjoy! Get the workbook here FREE: http://excelvbaisfun.com/mdocs-posts/excel-vba-format-textbox-hours-and-minutes-for-start-time-and-end-time/ [/et_pb_text][/et_pb_column][/et_pb_row][/et_pb_section][et_pb_section bb_built="1" _builder_version="3.0.105" global_module="14500" prev_background_color="#000000"][et_pb_row global_parent="14500" _builder_version="3.0.105"][et_pb_column type="4_4"][et_pb_text global_parent="14500" _builder_version="3.0.105"] You Might Also Like [/et_pb_text][et_pb_blog global_parent="14500" […]

Read More
How To Grab All Excel Sheet Names Into Listbox, Grab Column Headers Into Listbox

[et_pb_section bb_built="1" admin_label="section" _builder_version="3.0.47" next_background_color="#000000"][et_pb_row admin_label="row" _builder_version="3.0.47" background_size="initial" background_position="top_left" background_repeat="repeat"][et_pb_column type="4_4"][et_pb_text _builder_version="3.0.47" background_size="initial" background_position="top_left" background_repeat="repeat"] This week, I was asked how to load the sheet names onto a listbox and then when a sheet in that listbox is clicked - how to list the column headers in the second listbox! Sound crazy hard? No, it's […]

Read More
Excel VBA Userform Scrollbar Change By 10 Even When Dragging!

[et_pb_section bb_built="1" _builder_version="3.0.47" next_background_color="#000000"][et_pb_row _builder_version="3.0.47" background_size="initial" background_position="top_left" background_repeat="repeat"][et_pb_column type="4_4"][et_pb_text _builder_version="3.0.105"] Excel VBA Scrollbars are awesome for visually and easily changing a value, but there is one limitation - when you click the square in the middle and drag it, you can't automatically make it snap to the neares NN value! Until now! Check out how […]

Read More
Excel VBA UserForms #2

Excel VBA UserForms #2 Create a UserForm with 2 option buttons:  1 Sort by Employee ID or 2 Sort by Name. Part one, create the UserForm and give it buttons. First, bring up the VBA UserForm editor (F11), and add a new UserForm  using the dropdown in the upper left of the screen. Rename the UserForm to "sortform" […]

Read More
Excel VBA Userform Basics #1

[et_pb_section bb_built="1" next_background_color="#000000"][et_pb_row][et_pb_column type="4_4"][et_pb_text] UserForm Basics #1 Here, you'll learn to make a UserForm, add a button, and make clicking on that button hide the UserForm! Make a UserForm: Press Alt-F11 to bring up Visual Basics menu Click the drop down menu in the upper left hand and select UserForm: Press F4 to bring up […]

Read More

Excel VBA Is Fun

We believe Excel is one of the most versatile programs out there - and learning to program and automate it makes you very valuable!

You can prevent wasted time and errors, speed up tasks and become indispensable to your organization. 

See how our trainees have gotten raises, promotions and bonuses using their Excel Automation skills while building real problem-solving programs in Excel!
LEARN MORE
Copyright © 2024 ExcelVbaIsFun
X

Forgot Password?

Join Us

1
    1
    Your Cart
    linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram