...was another kind of fever (see the stamps one, lol) I was afflicted with, lasting for about three years while working for Orbotech.
Application.ScreenUpdating = False
No, I had no idea what it was, but I had a guide and mentor to follow, a colleague called Alex Alaluf, I got my own "logistics improvements" ideas to develop, and this tool was handy, available and (as I discovered lately) extremely powerful. I had only basic programmimg knowledge, the Visual Basic was (is) an extremely vast domain with relatively little good supporting literature (an exception being John Walkenbach; great books, but lacking sufficient depth and... quite expensive), and time (un)availability was a crucial element. So I started reading, writing basic routines, chasing Alex for advice, and starting to work very early in the morning until late in the evening to find the necessary time. Also taking jobs home, of course.
On Error Goto CanNotDeleteSCR
To make a long story short - in a matter of several months I became a specialist on the subject, at least in those aspects I needed, and created some great applications, mostly logistics and/or service oriented. The advantage being: INDEPENDENCE. I originated the ideas, developed them, created them, issued them, corrected them - all by myself. No need for budgets, chasing programmers, project definitions, lengthy discussions.., it was all BANG! DONE. And the results on the quality of services provided by logistics were not late in showing up.
Visual Basic in combination with XL is a terrifically powerful tool. The official logistics program (called OpenUPTIME) did the basic admin work. But it lacked hugely in many aspects, which my programs complemented in providing. Among the programs I created:
ActiveSheet.Shapes.AddShape(msoShapeRectangle, Ox - 9.8, Oy, 9.6, 6.4 + YSFor).Select
I defined Visual Basic programming an art. I still maintain this opinion, since there is place to so much creativity in this tool that no other definiton would suit it. Pity that there are no really complete books and guides (schools) to handle it completely. I guess that even afer 3 years I was 10% knowledge and 90% hole. But even with such limited knowledge - the resulting projects were (and can be) magnificent.