Click here to Skip to main content

Welcome to the Lounge

   

For lazing about and discussing anything in a software developer's life that takes your fancy.
The Lounge is rated PG. If you're about to post something you wouldn't want your kid sister to read then don't post it. No flame wars, no abusive conduct and please don't post ads.

Technical discussions are welcome, but if you need specific help please use the programming forums.


 
RantVisual Basic for mAsochists (VBA) PinmemberSixOfTheClock28-Dec-12 3:46 
Now before I start this rant, I mean no insult to any VBA programmers out there reading this. I could not have greater admiration for you for succeeding where I have failed in actually accomplishing anything in VBA for Excel without lines and lines of hacks and botched, messy code. I want to get the general consensus on this, as it has been bugging me no end.
 
My first gripe is that the VBA programming environment that comes with Office (2007) is to my eyes just utter tat. It is currently removing and inserting random whitespace here there and everywhere in what seems to be an overtly malicious attempt to mess with my head. The 'intellisense' and 'syntax highlighting' leave much to be desired, but I could whine about that all day, so I'll stop there.
 
In my opinion however, the absolute worst thing about the VBA editor that shipped with Excel 2007 is...
 
The environment alerts you to coding errors with - get this - a MODAL messagebox that totally interrupts what you're trying to accomplish by screaming in your face until you click the stupid 'OK' button.
 
Secondly it seems to be to be impossible, or at least highly impractical, to accomplish anything approaching an elegant solution to a problem using VBA in Excel. So far this project, I have been repeatedly flummoxed by the arcane, esoteric knowledge of all the peculiarities of VBA that seems to be required to do anything at all in the language with any degree of efficiency.
 
While I am far from being a VB guru, VB.NET is my main programming language alongside Java and also my main source of income. I was astonished to find that my half a decade of VB.NET experience did not help one jot with VBA.
 
Is this just me? Please tell me, because I'm not sure if the problem is on my end (very possible) or with whichever dark ritual was used to create this 'programming language' in the first place.
 
SixOfTheClock
A programming language is to a programmer what a fine hat is to one who is fond of fancy garden parties. Just don't try wearing any .NET language on your head. Some of them are sharp.

GeneralRe: Visual Basic for mAsochists (VBA) Pinmemberloctrice28-Dec-12 4:46 
GeneralRe: Visual Basic for mAsochists (VBA) Pinmemberharold aptroot28-Dec-12 4:56 
GeneralRe: Visual Basic for mAsochists (VBA) Pinmemberloctrice28-Dec-12 5:18 
GeneralRe: Visual Basic for mAsochists (VBA) PinmemberMember 46088982-Jan-13 6:57 
GeneralRe: Visual Basic for mAsochists (VBA) PinmemberFlorin Jurcovici2-Jan-13 3:19 
GeneralRe: Visual Basic for mAsochists (VBA) Pinmemberloctrice2-Jan-13 3:34 
GeneralRe: Visual Basic for mAsochists (VBA) PinmemberPIEBALDconsult28-Dec-12 4:47 
GeneralRe: Visual Basic for mAsochists (VBA) PinmemberMember 81169087-Jan-13 7:03 
GeneralRe: Visual Basic for mAsochists (VBA) PinmemberSentenryu28-Dec-12 4:48 
GeneralRe: Visual Basic for mAsochists (VBA) PinmemberPIEBALDconsult28-Dec-12 4:53 
GeneralRe: Visual Basic for mAsochists (VBA) PinmemberSentenryu28-Dec-12 5:07 
GeneralRe: Visual Basic for mAsochists (VBA) Pinmemberrbuchana28-Dec-12 6:11 
GeneralRe: Visual Basic for mAsochists (VBA) PinmemberSixOfTheClock28-Dec-12 7:51 
GeneralRe: Visual Basic for mAsochists (VBA) PinmemberSentenryu1-Jan-13 22:34 
GeneralRe: Visual Basic for mAsochists (VBA) PinmemberClifford Nelson28-Dec-12 7:09 
GeneralRe: Visual Basic for mAsochists (VBA) PinmemberRedDK28-Dec-12 8:21 
GeneralMessage Removed Pinmember_beauw_28-Dec-12 8:26 
GeneralRe: Visual Basic for mAsochists (VBA) PinmemberPaul Conrad28-Dec-12 16:44 
GeneralRe: Visual Basic for mAsochists (VBA) PinmemberJonathan C Dickinson1-Jan-13 21:46 
GeneralRe: Visual Basic for mAsochists (VBA) Pinmemberfatman453-Jan-13 19:56 
GeneralRe: Visual Basic for mAsochists (VBA) PinmemberCHill601-Jan-13 22:30 
GeneralRe: Visual Basic for mAsochists (VBA) Pinmemberstmoore12-Jan-13 3:10 
GeneralRe: Visual Basic for mAsochists (VBA) PinmemberCodeBubba2-Jan-13 4:25 
GeneralRe: Visual Basic for mAsochists (VBA) PinmemberOffCenter2-Jan-13 5:52 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web01 | 2.8.140827.1 | Last Updated 29 Aug 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid