I work full time as a VBA developer. I'd prefer to work in a more robust language, and eventually will be transitioning away from the Access Database I'm building/maintaining into writing a VB.NET/SQL Version of the same application.

If you're skilled with VBA, try your hand at other languages like Java, or especially VB.NET (syntax is very very similar). You may be able to land a junior role with one of those, using demonstrable knowledge of VBA as your background.

My background is mostly in Java and PHP. When I applied for my current job I explained that I'd worked lightly with VBA but was far from expert in it, but that I also have a formal education in software design that doesn't come with learning VBA as an add-on to Office. Now I've been using it 40 hours a week for the better part of a year