User talk:Klever

I notice that you're using <lang VBA> for your VBA examples. Might I suggest using <lang vb> instead? Then the examples will get highlighted properly. (It's what I do.) -- Erik Siers 19:50, 4 October 2011 (UTC)

If there are significant differences between the languages it might be better to get VBA added to GeSHi. There are some instructions here. User:BenBE is our contact for the GeSHi project. If the languages aren't that different it's probably not worth it, but it may not be too difficult to get a language file set up (multiple users have done it before so I don't think it's too hard). --Mwn3d 20:06, 4 October 2011 (UTC)

There aren't, really. Visual Basic 4/5/6 is a general-purpose implementation of VBA, while the VBA embedded in apps such as Word, Excel, etc is geared toward that specific app -- things like the Document object in MS Word and the Spreadsheet object in MS Excel. (Forms also work somewhat differently.) But VBA can do literally anything that VB6 can (except compile), and VB can do anything that VBA can do, and the code is almost identical.

Most non-.Net VB code can be run from VBA with little or no changes, and vice-versa. -- Erik Siers 20:19, 4 October 2011 (UTC)

Hm. This suggests a way to fix language categorization for VB and VB.Net. On one hand, you have Visual Basic.NET. On the other, you have Visual Basic for Applications. Categorization ambiguities between VB 4/5/6, VB.Net and VBA were a thorn in my side from nearly the very beginning of this site. That still leaves VB 1/2/3, though. (And I played with VB for DOS as a kid. I don't know where that fits) --Michael Mol 13:57, 5 October 2011 (UTC)

VB can be divided into 4 broad categories: VBDOS, early VB, COM VB, and VB .Net.

• VBDOS is really part of the QuickBASIC family -- in fact, VBDOS can compile most QB programs without change, and could be considered the "missing link" between QB and "real" VB. (There is a Win16 program included with VBDOS and maybe VB1 that can translate back-n-forth.) See this section of WP's VB page for a tiny bit of info. (The "forms" part of VBDOS is almost identical to VB1; it's everything else that needed translating.)
• Early VB is VB1-3. The language is essentially the same as VB4-6, but the internals are a bit different, they're 16-bit only, and they use VBX controls instead of COM (OLE, ActiveX, OCX) controls.

EDIT: I wouldn't worry about the Win16 VB's much; they're almost certainly not in use any more. As far as programmers are concerned, early VB can probably be grouped with COM VB, for the most part. The language doesn't change very much from, say, 3 to 4, or even 1 to 6; someone who learned on VB1 could jump to VB6 and be up to speed within a day. -- Erik Siers 17:28, 5 October 2011 (UTC)

• COM VB is VB4 through VB6, and VBA. They are Win32 (VB4 also has a Win16 version) and use ActiveX (OCX) components.
• VB.Net isn't really VB, as far as most "classic" VB programmers are concerned. It's got a VB-ish syntax, but the differences are great enough that it's really a separate language.

Hope that helps. Karl Peterson is one of the main VB experts on the www; I'll try poking him and see if he'll swing by and add in his 2¢. -- Erik Siers 17:18, 5 October 2011 (UTC)