I think the problem is not doing CTLR+clk...clk...clk, but to do it over and over again.
In Jupyterlab I help myself by defining lists of shapes.
eg:
myRedShapes = list(vWin.Selection)
myBlueShapes ...
and reusing them - eg:
[vWin.Select(shp,visSelect) for shp in myRedShapes]
or
for shp in myBlueShapes:
shp.Cells(xyz).Formula = 123
so far for the unuseful REPL functionality of Jupyterlab (

).
For VBA I thought about writing a modeless form with a list holding lists of shapes.
There would be a "save selection as..." button, probably also a delete and a re-define one.
Selecting an item in the list would select the according shapes.
The list items would be stored in the shapesheet of the doc or the page.
There would be also a possibility to have dynamic lists - that is where you define a condition instead of having a fixed list.
The selection routine will need to cover the case when shapes are deleted and update the item accordingly.
... unfortunately I have it already in Jupyterlab, so my motivation to write it in VBA is not the highest.
--> could be something for Paul's tool collection
Continuation here:http://visguy.com/vgforum/index.php?topic=9904.msg45283#msg45283