Tag Archives: VBA

YouTube: Tips for Making a How-To Video

This is my first and possibly only foray into the madness that is constructing a YouTube video. I’ve been watching the Vlog Brothers for years, and I’ve never appreciated the effort that goes into it. Pick a topic, write a script, animate the graphics, trim clips, find background music, and also, cut around all your foul language because YouTube does not take kindly to that.

I did that after doing a lot of other research on the basics of YouTube for a non-YouTuber.

So, as a supplement to this VBA video tutorial, I’ve condensed my background research for anyone out there who might also be considering a jump from WordPress to YouTube.

Continue reading

Advertisements
Tagged , , , , , , , , , ,

VBA: What Exactly is a FileSystemObject?

I really wish Hyperbole and a Half was still posting.

It’s friggin’ magic. FileSystemObject is how you run scripts on your files and folders in VBA. You want to create 100 files on your desktop automatically? It’ll let you do that. You want to delete files with specific names in a directory? It’ll let you do that too. It’s also pretty crucial to viruses like Anna Kournikova and the Love Bug, which I’ve been looking at recently. So here’s how to make a FileSystemObject.

Continue reading

Tagged , , , , , , , ,

VBA: How to Customize Font to Specific Text in Word

Header2

Short one today.

I’m getting ready to write a post on worms and realized it’d be really nice if Word could mimic the font formatting that happens in the Visual Basic editor. Color coding helps me see relationships a lot easier when I’m trying to get my head around another person’s script.

Continue reading

Tagged , , , , , ,

VBA: How to Use VLookUp in a Macro

Header

Alright, here’s something I’ve been meaning to learn for weeks. It’s probably going to be the most boring post of all time for anyone who isn’t an Excel nerd. In fact, if you aren’t an Excel nerd, just run. Run far, far away.

Continue reading

Tagged , , , , , , , , , ,

VBA: How to Exclude Numbers from a List

Header

Alright, I ran short of time this week, so I don’t have a tutorial. But I DO have another fun UDF (User-Defined Function)–this one takes two parameters. Both need to be strings made of comma separated numbers. The function excludes the second set of numbers from the output.

Continue reading

Tagged , , , , , , , ,

VBA: How to Get A List From a Range of Numbers

Header

A couple months ago, I did the exact opposite of this. I called it the ListToRange() Function. It’s weirdly helpful at work because I have to go back and forth between having numbers listed out and then having them clustered for other things.

Continue reading

Tagged , , , , , , ,

VBA: What is a Range Object?

Range Objects

“Range object” is an unnecessarily intimidating term for a collection of cells within your workbook. Say you need to run some complicated math or formatting over the same cells over and over throughout a long script. You could call on the column number and row every damn time, but who wants to do all that typing?

Continue reading

Tagged , , , , , , ,