Asking “at the same time†implies running them as threaded calls? VB6, the
last non .NET version of VB (VB .NET does support threads as do all .NET
languages), can run threads, so I’m guessing it is technically possible with
VBA, although I have never seen that. It’s fairly advanced programming,
having to run several Win32 functions and understanding the threads process.
Instead, make sure that’s what you want to do. Is it absolutely required
that they run at the same time? VBA is not known for its processing speed and
users understand there may be wait periods. I’d suggest rethinking the
solution, and take an approach that uses conventional VBA processing, one
macro at a time, and perhaps resequencing the order of events as a workaround.
