Click here to Skip to main content
13,195,710 members (54,522 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.
 
GeneralRe: RIP Stormin' Normin Pin
Clifford Nelson28-Dec-12 9:51
memberClifford Nelson28-Dec-12 9:51 
GeneralRe: RIP Stormin' Normin Pin
PHS24128-Dec-12 9:16
memberPHS24128-Dec-12 9:16 
GeneralRe: RIP Stormin' Normin Pin
BrainiacV28-Dec-12 15:06
memberBrainiacV28-Dec-12 15:06 
GeneralWeb-host question - m6.net Pin
Nish Sivakumar28-Dec-12 4:12
mvpNish Sivakumar28-Dec-12 4:12 
GeneralRe: Web-host question - m6.net Pin
Nish Sivakumar28-Dec-12 4:18
mvpNish Sivakumar28-Dec-12 4:18 
GeneralRe: Web-host question - m6.net Pin
OriginalGriff28-Dec-12 4:40
mvpOriginalGriff28-Dec-12 4:40 
GeneralRe: Web-host question - m6.net Pin
Nish Sivakumar28-Dec-12 4:43
mvpNish Sivakumar28-Dec-12 4:43 
GeneralRe: Web-host question - m6.net Pin
Stephane Routelous28-Dec-12 4:53
memberStephane Routelous28-Dec-12 4:53 
GeneralRe: Web-host question - m6.net Pin
Nish Sivakumar28-Dec-12 8:27
mvpNish Sivakumar28-Dec-12 8:27 
GeneralRe: Web-host question - m6.net Pin
Amar Chaudhary28-Dec-12 4:54
memberAmar Chaudhary28-Dec-12 4:54 
GeneralRe: Web-host question - m6.net Pin
Nish Sivakumar28-Dec-12 8:27
mvpNish Sivakumar28-Dec-12 8:27 
GeneralRe: Web-host question - m6.net Pin
Chris Quinn28-Dec-12 5:00
memberChris Quinn28-Dec-12 5:00 
GeneralRe: Web-host question - m6.net Pin
Nish Sivakumar28-Dec-12 8:27
mvpNish Sivakumar28-Dec-12 8:27 
RantVisual Basic for mAsochists (VBA) Pin
SixOfTheClock28-Dec-12 3:46
memberSixOfTheClock28-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.
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.


modified 2-Jul-17 15:32pm.

GeneralRe: Visual Basic for mAsochists (VBA) Pin
loctrice28-Dec-12 4:46
memberloctrice28-Dec-12 4:46 
GeneralRe: Visual Basic for mAsochists (VBA) Pin
harold aptroot28-Dec-12 4:56
memberharold aptroot28-Dec-12 4:56 
GeneralRe: Visual Basic for mAsochists (VBA) Pin
loctrice28-Dec-12 5:18
memberloctrice28-Dec-12 5:18 
GeneralRe: Visual Basic for mAsochists (VBA) Pin
Member 46088982-Jan-13 6:57
memberMember 46088982-Jan-13 6:57 
GeneralRe: Visual Basic for mAsochists (VBA) Pin
Florin Jurcovici2-Jan-13 3:19
memberFlorin Jurcovici2-Jan-13 3:19 
GeneralRe: Visual Basic for mAsochists (VBA) Pin
loctrice2-Jan-13 3:34
memberloctrice2-Jan-13 3:34 
GeneralRe: Visual Basic for mAsochists (VBA) Pin
PIEBALDconsult28-Dec-12 4:47
memberPIEBALDconsult28-Dec-12 4:47 
GeneralRe: Visual Basic for mAsochists (VBA) Pin
Member 81169087-Jan-13 7:03
memberMember 81169087-Jan-13 7:03 
GeneralRe: Visual Basic for mAsochists (VBA) Pin
Sentenryu28-Dec-12 4:48
memberSentenryu28-Dec-12 4:48 
GeneralRe: Visual Basic for mAsochists (VBA) Pin
PIEBALDconsult28-Dec-12 4:53
memberPIEBALDconsult28-Dec-12 4:53 
GeneralRe: Visual Basic for mAsochists (VBA) Pin
Sentenryu28-Dec-12 5:07
memberSentenryu28-Dec-12 5:07 
GeneralRe: Visual Basic for mAsochists (VBA) Pin
rbuchana28-Dec-12 6:11
memberrbuchana28-Dec-12 6:11 
GeneralRe: Visual Basic for mAsochists (VBA) Pin
SixOfTheClock28-Dec-12 7:51
memberSixOfTheClock28-Dec-12 7:51 
GeneralRe: Visual Basic for mAsochists (VBA) Pin
Sentenryu1-Jan-13 22:34
memberSentenryu1-Jan-13 22:34 
GeneralRe: Visual Basic for mAsochists (VBA) Pin
Clifford Nelson28-Dec-12 7:09
memberClifford Nelson28-Dec-12 7:09 
GeneralRe: Visual Basic for mAsochists (VBA) Pin
RedDK28-Dec-12 8:21
memberRedDK28-Dec-12 8:21 
GeneralRe: Visual Basic for mAsochists (VBA) Pin
Paul Conrad28-Dec-12 16:44
memberPaul Conrad28-Dec-12 16:44 
GeneralRe: Visual Basic for mAsochists (VBA) Pin
Jonathan C Dickinson1-Jan-13 21:46
memberJonathan C Dickinson1-Jan-13 21:46 
GeneralRe: Visual Basic for mAsochists (VBA) Pin
fatman453-Jan-13 19:56
memberfatman453-Jan-13 19:56 
GeneralRe: Visual Basic for mAsochists (VBA) Pin
CHill601-Jan-13 22:30
memberCHill601-Jan-13 22:30 
GeneralRe: Visual Basic for mAsochists (VBA) Pin
stmoore12-Jan-13 3:10
memberstmoore12-Jan-13 3:10 
GeneralRe: Visual Basic for mAsochists (VBA) Pin
CodeBubba2-Jan-13 4:25
memberCodeBubba2-Jan-13 4:25 
GeneralRe: Visual Basic for mAsochists (VBA) Pin
OffCenter2-Jan-13 5:52
memberOffCenter2-Jan-13 5:52 
GeneralRe: Visual Basic for mAsochists (VBA) Pin
CHill602-Jan-13 6:04
memberCHill602-Jan-13 6:04 
GeneralRe: Visual Basic for mAsochists (VBA) Pin
Member 46088982-Jan-13 7:01
memberMember 46088982-Jan-13 7:01 
GeneralRe: Visual Basic for mAsochists (VBA) Pin
Earl Truss2-Jan-13 8:20
memberEarl Truss2-Jan-13 8:20 
GeneralRe: Visual Basic for mAsochists (VBA) Pin
BillWoodruff2-Jan-13 0:43
memberBillWoodruff2-Jan-13 0:43 
GeneralRe: Visual Basic for mAsochists (VBA) Pin
Cindy Meister2-Jan-13 1:43
memberCindy Meister2-Jan-13 1:43 
GeneralRe: Visual Basic for mAsochists (VBA) Pin
DanielSheets2-Jan-13 2:58
memberDanielSheets2-Jan-13 2:58 
GeneralRe: Visual Basic for mAsochists (VBA) Pin
John Atten2-Jan-13 3:31
memberJohn Atten2-Jan-13 3:31 
GeneralRe: Visual Basic for mAsochists (VBA) Pin
Kent K2-Jan-13 4:06
memberKent K2-Jan-13 4:06 
JokeRe: Visual Basic for mAsochists (VBA) Pin
RafagaX2-Jan-13 5:50
memberRafagaX2-Jan-13 5:50 
GeneralRe: Visual Basic for mAsochists (VBA) Pin
rdmjr2-Jan-13 10:23
memberrdmjr2-Jan-13 10:23 
GeneralRe: Visual Basic for mAsochists (VBA) Pin
JonShops2-Jan-13 16:10
memberJonShops2-Jan-13 16:10 
GeneralRe: Visual Basic for mAsochists (VBA) Pin
Stuart Dootson3-Jan-13 14:34
memberStuart Dootson3-Jan-13 14:34 
GeneralNew Year's Warning: don't hold iPhone near feeding elephant ! Pin
BillWoodruff27-Dec-12 20:04
memberBillWoodruff27-Dec-12 20:04 

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 |
Web03 | 2.8.171019.1 | Last Updated 20 Oct 2017
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid