Click here to Skip to main content
12,623,511 members (32,600 online)

Welcome to the Lounge

   

For discussing anything related to a software developer's life. Technical discussions are encouraged, but click here to ask your programming questions.

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, no programming questions and please don't post ads.
 
RantVisual Basic for mAsochists (VBA) Pin
SixOfTheClock28-Dec-12 4:46
memberSixOfTheClock28-Dec-12 4: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) Pin
loctrice28-Dec-12 5:46
memberloctrice28-Dec-12 5:46 
GeneralRe: Visual Basic for mAsochists (VBA) Pin
harold aptroot28-Dec-12 5:56
memberharold aptroot28-Dec-12 5:56 
GeneralRe: Visual Basic for mAsochists (VBA) Pin
loctrice28-Dec-12 6:18
memberloctrice28-Dec-12 6:18 
GeneralRe: Visual Basic for mAsochists (VBA) Pin
Member 46088982-Jan-13 7:57
memberMember 46088982-Jan-13 7:57 
GeneralRe: Visual Basic for mAsochists (VBA) Pin
Florin Jurcovici2-Jan-13 4:19
memberFlorin Jurcovici2-Jan-13 4:19 
GeneralRe: Visual Basic for mAsochists (VBA) Pin
loctrice2-Jan-13 4:34
memberloctrice2-Jan-13 4:34 
GeneralRe: Visual Basic for mAsochists (VBA) Pin
PIEBALDconsult28-Dec-12 5:47
memberPIEBALDconsult28-Dec-12 5:47 
GeneralRe: Visual Basic for mAsochists (VBA) Pin
Member 81169087-Jan-13 8:03
memberMember 81169087-Jan-13 8:03 
GeneralRe: Visual Basic for mAsochists (VBA) Pin
Sentenryu28-Dec-12 5:48
memberSentenryu28-Dec-12 5:48 
GeneralRe: Visual Basic for mAsochists (VBA) Pin
PIEBALDconsult28-Dec-12 5:53
memberPIEBALDconsult28-Dec-12 5:53 
GeneralRe: Visual Basic for mAsochists (VBA) Pin
Sentenryu28-Dec-12 6:07
memberSentenryu28-Dec-12 6:07 
GeneralRe: Visual Basic for mAsochists (VBA) Pin
rbuchana28-Dec-12 7:11
memberrbuchana28-Dec-12 7:11 
GeneralRe: Visual Basic for mAsochists (VBA) Pin
SixOfTheClock28-Dec-12 8:51
memberSixOfTheClock28-Dec-12 8:51 
GeneralRe: Visual Basic for mAsochists (VBA) Pin
Sentenryu1-Jan-13 23:34
memberSentenryu1-Jan-13 23:34 
GeneralRe: Visual Basic for mAsochists (VBA) Pin
Clifford Nelson28-Dec-12 8:09
memberClifford Nelson28-Dec-12 8:09 
GeneralRe: Visual Basic for mAsochists (VBA) Pin
RedDK28-Dec-12 9:21
memberRedDK28-Dec-12 9:21 
GeneralMessage Removed Pin
_beauw_28-Dec-12 9:26
member_beauw_28-Dec-12 9:26 
GeneralRe: Visual Basic for mAsochists (VBA) Pin
Paul Conrad28-Dec-12 17:44
memberPaul Conrad28-Dec-12 17:44 
GeneralRe: Visual Basic for mAsochists (VBA) Pin
Jonathan C Dickinson1-Jan-13 22:46
memberJonathan C Dickinson1-Jan-13 22:46 
GeneralRe: Visual Basic for mAsochists (VBA) Pin
fatman453-Jan-13 20:56
memberfatman453-Jan-13 20:56 
GeneralRe: Visual Basic for mAsochists (VBA) Pin
CHill601-Jan-13 23:30
memberCHill601-Jan-13 23:30 
GeneralRe: Visual Basic for mAsochists (VBA) Pin
stmoore12-Jan-13 4:10
memberstmoore12-Jan-13 4:10 
GeneralRe: Visual Basic for mAsochists (VBA) Pin
CodeBubba2-Jan-13 5:25
memberCodeBubba2-Jan-13 5:25 
GeneralRe: Visual Basic for mAsochists (VBA) Pin
OffCenter2-Jan-13 6:52
memberOffCenter2-Jan-13 6:52 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    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.161128.1 | Last Updated 4 Dec 2016
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid