Hacker Newsnew | past | comments | ask | show | jobs | submit | vic20forever's commentslogin

You are correct. But, that's about the only difference between VBA and VB. I was a VB developer for 10 years before I wrote my first VBA application (in Excel), and I was surprised when everything I tried to do in VBA just worked(TM).


There are plenty more like VB 5 and 6 changed component architecture from VBX, to OCX (COM based), while adding features to do COM development in VB directly.

VB 5 introduced proper AOT compilation, based on VC++ backend, which was further improved in VB 6.

The debugger / REPL experience was much better on VB than VBA.

You cannot really use most VB components in Excel / VBA unless AddIn support is enabled.


Say whaaat? VB (v.3 through v.6, at least) wouldn't compile if you misspelled the name of a function or subroutine.


VB had case insensitive name resolution.


Yes, but that was the standard behavior in DOS & Windows world (not including C/C++). We thought that case sensitivity was the broken behavior ;)

I was referring to the parent's statement "If a method or function call is similar enough to an existing one or a common one from other languages, to just have it silently use that." A compiler that substitutes a different function for the one I specified because it "knows what I really want" is horrifying.


When I studied in Russia (early 90s, it was still the USSR), we learned to answer the phone with слушаю (I'm listening)



"Shoot first, ask questions later"[0] when cutting staff seems like a delusional idea to me.

[0] https://news.ycombinator.com/item?id=33496808


Moving a window: Alt-Space, M, arrow keys


If you Alt-Space, M, and press one of the arrow keys, the windows will 'stick' to your mouse cursor so you can just wiggle your mouse after they key combo to bring it to you.


The old CUA, Windows 3.0 corner square has an oblong rectangle that represents the space bar (at least in my mind). Unless the window is a child window, in which case the shortcut is Alt-Hyphen[1], and I haven't used that shortcut in many years. The fashion for tabs has probably made that useless.

[1] http://www.robelle.com/smugbook/win3x.html


I was inspired by nostalgia to do the research via archive.org: This shortcut goes back to Windows 2.0, almost 35 years ago. I remembered it from the 3.1 days.


OneNote can do simple calculations for you: https://support.microsoft.com/en-us/office/insert-and-calcul...


Click on the '+ help' label in the upper-right corner for a detailed description.


Please don't do this, Mozilla.

I have a lot of open tabs on my 1920 x 1080 monitor, and switching from compact density to default (I just tested this) reduced the amount of visible text on each tab such that I couldn't identify what most of the tabs contained.

In other words, if you have a lot of tabs open at once, the reduction in usability is significant.


Edit and continue, Visual Basic 3, 1994

After adding a major piece of new functionality to my app, I would step through the new code, fixing each bug as it appeared, and then continue stepping. Being able to produce bug-free code after only one run-through just blew my mind.


Consider applying for YC's Winter 2027 batch! Applications are open till November 2.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: