Hello and welcome to the forum.
We can help you with VBA easily enough, but I'm confused. How do microcontrollers fit in? Do you have a VBA execution module for those controllers? I'm not saying it wouldn't be GREAT to have a higher-level language that can manage properties and methods in a microcontroller context. I wish I had something like that when I was working for an oil pipeline company. But there has to be a way to get the VBA to the controllers in a way that can be executed, and VBA has a high memory overhead for its execution routines.