Profile cover photo
Profile photo
Ryan Wells
371 followers -
VBA Developer and Nuclear Engineer
VBA Developer and Nuclear Engineer

371 followers
About
Posts

Post has attachment
We told you we'd keep telling you all the neat things you can do with VBA FileSystemObject in Excel. This tutorial shows you how to use FSO to navigate folders and subfolders and list all the files with certain extensions: https://wellsr.com/vba/2018/excel/list-files-in-folder-and-subfolders-with-vba-filesystemobject/
Add a comment...

Post has attachment
One day we're talking about advanced VBA topics, like the FileSystemObject, and the next day we're discussing basics, like how to show a UserForm in VBA. We cover it all! https://wellsr.com/vba/2018/excel/vba-show-userform-with-show-method/
Add a comment...

Post has attachment
You'll definitely want to bookmark this page (if people still do that?). Here's a description of all the methods of the VBA FileSystemObject. We'll frequently add links to new tutorials describing how to use many of these methods in Excel. https://wellsr.com/vba/2018/excel/introduction-to-the-vba-filesystemobject/
Add a comment...

Post has attachment
The Excel Application.InputBox is so much better than the generic VBA InputBox. Take a look at this tutorial to find out why Application.InputBox is the best way to interact with the user and collect simple user input.

https://wellsr.com/vba/2018/excel/use-application-inputbox-to-prompt-for-vba-user-input/
Add a comment...

Post has attachment
Just when you think you learned everything there is to know about concatenating strings in VBA, you hear another neat trick. Check out this article full of tips, tricks and common errors people make when using the & operator.
https://wellsr.com/vba/2018/excel/vba-concatenate-strings-with-ampersand/
Add a comment...

Post has attachment
Fade your VBA userforms in and out with the macros in this tutorial. It's great for making splash screens!

https://wellsr.com/vba/2018/excel/vba-fade-userform-in-and-out/
Add a comment...

Post has attachment
Did you know that in VBA 10.5 / 3.5 does not equal 10.5 \ 3.5? Find out more about the often-forgotten backslash operator and how it performs integer division. (Spoiler alert: it doesn't round the quotient!) https://wellsr.com/vba/2018/excel/integer-division-with-vba-backslash-operator/
Add a comment...

Post has attachment
Continuing with my VBA array theme, here's a neat little macro to reverse the order of the elements in your array. I wrote it because I was too lazy to change my sorting algorithms to sort from largest to smallest instead of smallest to largest... https://wellsr.com/vba/2018/excel/reverse-order-of-array-with-vba/
Add a comment...

Post has attachment
This VBA quicksort macro sorted my 25,000 element array 323x faster than the sluggish bubble sort macro I showed last week. It finished in only 0.07 seconds! The bubble sort macro took 22.64 seconds...

https://wellsr.com/vba/2018/excel/vba-quicksort-macro-to-sort-arrays-fast/
Add a comment...

Post has attachment
Bubbles, bubbles, bubbles! Let's learn how to sort small arrays from smallest to largest with this Excel VBA bubble sort macro: https://wellsr.com/vba/2018/excel/vba-bubble-sort-macro-to-sort-array/

(P.S. You don't wanna use the bubble sort algorithm to sort really large arrays! It'll be painfully slow.)
Add a comment...
Wait while more posts are being loaded