VBA allows you to adopt a few lazy habits that can come back to haunt you later on. One of these is not needing to declare your variables prior to using them. Since VBA requires variables to have a type this leads to possible type confusion (you attempt to store the wrong type of value into a variable) and code that is more difficult to read.
Option Explicit to the top of your modules forces you to declare your variables (the IDE will prompt you when you forget). You can set-up the IDE to automatically add this option so you don’t forget.
In the VBA IDE go to Tools > Options
Ensure that Require Variable Declaration is checked. All new workbooks and modules will have
Option Explicit added.
Note: Your existing workbooks will not have
Option Explicit added automatically. You will need to add it in manually (and fix up any missing declarations).
On February 20 (12-1:30), the WebDev P2P group I co-champion will be holding our next talk: Introduction to Web APIs by (fellow co-champion) Brad Genereaux.
Are you Agile? Want to be more Agile? Want to retrospective better? Want to see Sean Yo (@seanyo) and myself ham it up like it’s comedy hour (maybe that won’t happen). Then come on out to our upcoming talk Real World Retrospectives as part of the Agile/Lean P2P group through Communitech.
– from Linchpin
We’re in the middle of a cold spell here in Ontario and the roads are slick with slush. Driving home from work my car was having trouble making it up a hill. With other anxious drivers behind me and me being stuck going 20 kph my gut reaction was to push harder on the gas. If you live in frosty regions, you’ll know that only makes it worse. The best option is to let up on the gas, let the wheel’s catch and start again.
Ease up. Get your bearings. Slow down to speed up.
In this post I will go through setting up XAMPP and Eclipse to let you work with PHP and one of its unit testing frameworks PHPUnit.
In Excel (this was done in Excel 2010, but the version shouldn’t matter), you can quickly resize a number of rows to be the same height using this quick trick.
If you have multiple controls on a form that are using identical event handlers, you can reduce duplication in your code by having all the controls point to only one of the event handler functions.
Really short notice, but I’m giving a guest lecture in the User Experience Guest Lecture Series at Conestoga College tomorrow evening (Oct 29).
Are you a web developer in KW? Then come and join us for the first Peer2Peer session September 12 (12:00-1:30) at Communitech. Here’s the official blurb:
Topics: Bootstrap & AngularJS
Speakers: Aren Patel, Web Developer at Google (formerly BufferBox) & Jared Bydeley, Software Developer at Agfa Healthcare