posted by Nate Moore on December 15th, 2014 at 7:21 PM
0 Comments added to this post
The final video of 2014 and the final video in our series on VBA and macros is a practical example for medical practices.
Read More ...
posted by Nate Moore on December 11th, 2014 at 4:59 PM
Here's a new article with everything you need to know about documenting your spreadsheet using Excel's comments feature.
posted by Nate Moore on December 8th, 2014 at 7:51 PM
Today we put several of the things we’ve learned over the past Excel Videos together to build a custom function in VBA.
posted by Nate Moore on December 1st, 2014 at 7:41 PM
Case statements are more concise and easier to read than the If..ElseIf statements we’ve been discussing.
posted by Nate Moore on November 24th, 2014 at 4:51 PM
The pre-authorization example gets even more precise in the last Excel Video about If.
posted by Nate Moore on November 17th, 2014 at 7:43 PM
You can add more power to your If statements by using Else and ElseIf.
posted by Nate Moore on November 10th, 2014 at 7:30 PM
Adding If statements makes your code much more powerful.
posted by Nate Moore on November 3rd, 2014 at 4:57 PM
Today we’ll work through how to capture user input from Message Boxes.
posted by Nate Moore on October 27th, 2014 at 7:41 PM
Today we’ll take Message Boxes a step further by customizing the message buttons.
posted by Nate Moore on October 20th, 2014 at 7:11 PM
Here’s the first of three videos on Message Boxes in Excel.
posted by Nate Moore on October 13th, 2014 at 7:37 PM
One final video about looping…
posted by Nate Moore on October 6th, 2014 at 8:08 PM
If you watched Excel Video 429, this video will make a lot of sense as another way to loop.
posted by Nate Moore on September 29th, 2014 at 5:38 PM
Here’s another way to loop through data with VBA.
posted by Nate Moore on September 22nd, 2014 at 7:28 PM
We’ve spent several Excel Videos looping through rows and columns in a worksheet. Here’s a way to loop through Excel objects in your workbook.
posted by Nate Moore on September 15th, 2014 at 9:06 PM
If you find a problem as you’re looping through data, here’s how to stop the loop so you can fix the problem.
posted by Nate Moore on September 8th, 2014 at 6:16 PM
Here’s how to make a loop inside another a loop…
posted by Nate Moore on September 3rd, 2014 at 7:19 PM
Now that you're familiar with cutting, copying, and pasting data, I've posted a new article on Paste Special.
posted by Nate Moore on September 1st, 2014 at 6:25 PM
Here’s one line of code that makes your macros much easier to run as the size of your data changes.
posted by Nate Moore on August 25th, 2014 at 6:38 PM
Here’s how to make your loop shade alternate rows.
posted by Nate Moore on August 18th, 2014 at 4:42 PM
We’ll start discussing loops in Excel Video 423.