I think you are confusing Visual Basic with Visual Basic for Applications (VBA). The former is an independent programming language, the later is only for embedding into other applications (such as Microsoft Office). VBA is an embedded version of Visual Basic, it is missing a few features (most importantly the ability to compile to .EXE files).

There was Visual Basic for Windows 1.0 and Visual Basic for MS-DOS 1.0. The UI frameworks were completely different – Windows was GUI, MS-DOS was character mode. The Windows versions continued on until VB6, before being replaced by the very different Visual Basic.NET. Visual Basic for MS-DOS was discontinued after 1.0.