Using Flash to replace VBA?

The short answer to this question is: YES.

Flash has evolved from being an web animation program to a full fledged application framework. It includes built in drag-and-drop UI components, data binding along with a powerful object oriented language that looks like a cross between Java and Javascript: Flash Actionscript.

Since Flash is a vector based engine, it provides a pixel accurate layout capability … that means you can produce any type of layout / UI you could possibly want for your application.

Adobe has created a framework for Flash called Flex. This extends Flash and provides a very rich set of tools for building applications for both the Web and the desktop. To get you Flash based applications on the desktop, Adobe has created the Air framework.