How to select all ActiveX objects in an area using a mouse in Excel?
Posted
by
enderland
on Super User
See other posts from Super User
or by enderland
Published on 2013-10-31T16:23:44Z
Indexed on
2013/10/31
22:00 UTC
Read the original article
Hit count: 146
Because of this problem with ActiveX objects changing size, I am not grouping my ActiveX objects in my Excel worksheet. Grouping them causes my solution hack to not work which is quite annoying.
However, I often times want to be able to essentially use the mouse and select a region and then select all ActiveX objects contained in the region. This would also be useful for easily selecting objects to group them initially.
Basically:
- Use mouse to select area
- Automatically select all ActiveX components in region
I'm fine with a VBA solution if needed.
How can I do this?
© Super User or respective owner