This means that it needs to be local to you, but as we don't know where you live, it's very difficult to help.
There should be lots of options. I live in a small city, and we have local places that offer that. The city I lived in previously did as well.
Recommend that you check local colleges (especially community colleges), as well as professional training centers.
Some simple Google searches should put you on the right path.
For example, a simple Google search of "Excel VBA training in Atlanta" returned a ton of matches.
I have seen that shift with a lot of the learning centers in the past few years, but I would not expect most colleges to do that (as long as you are looking at "brick and mortar" college institutions, and not online colleges). You might need to do a little digging, and call some places. If you talk to some local colleges, if they do not offer what you are looking for, they may be able to point you in the right direction regarding what exists locally that meets your criteria.I have done that but when you dig into them they are online instructors where you sit in a classroom and someone teaches remotely "Online led."