Your use case is exactly addressed by our product called PI Vision. In it, event frames can be used in place of batch.
To apply the time range of an event to all symbols on the display, right-click the event and then click Apply Time Range.
As you know, we are moving from Batch to Event Frames in the PI System. We even made a tool for that one time migration in PI Server 2017 R2.
Therefore, my advice would be not to spend time coding up a custom solution in VBA which is not future proof and instead start exploring PI Vision which is the visualization platform that we recommend now.