On Friday night, I began reading my way through PED 2nd Edition. After something weird happened with Excel, (I think because I have Excel 2003 and 2007 installed,) I got the bright idea to create a very simple Windows Forms application. I figured that I could make a really easy math game for my daughter. (I’ll see about posting it over the next few days.)
So cool thing hereâ€¦ with very minimal VB.NET experience, I was able to knock up a fully working simple math game in about 3 hours that will install on Windows XP and Windows Vista. I was pretty damn impressed.
At any rate, here I am today, back working in Excel. And I can now say that I’m rather disgruntled with the state of the IDE for Excel VBA.
Despite gnashing my teeth on certain stuff in VB.NET, the IDE in VS2008 is awesome. Maybe it’s for the big things, and I’m sure that there will be VBA IDE things I’ll miss, but it’s the little things that made my day. Little things like this:
- You can collapse procedures/function and even entire regions of code. That seriously rocks!
- You type in With “whatever”, and it automatically puts in the End With. Actually, all constructs are like thisâ€¦ For Each, Select Case, Try/Catch and so on. Very, very cool!
- The indenting everywhere is automatic.
- The intellisense always suggests available items. I find this somewhat hit and miss in Excel’s IDE for some reason.
I really wish that they add the features above into our tired old IDE. It would make things so much faster for typing up code from scratch!