Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Thank you for such comprehensive code, Greg. I'll try it out.
I did finally notice what might be an alternate way to do this. If the shapes are ActiveX objects, I believe this could be done by selecting all the objects together either by shift-clicking them, or dragging the Select Objects outline around all the objects, then right-clicking the group, selecting properties, and setting the appropriate properties (Height, Width, Left) for the entire group. It would seem that your code might apply to more than just ActiveX objects, so that would be an advantage to it. Thanks again for providing it. "Greg Wilson" wrote in message ... Correction to my post: I left out the declaration: Option Base 1. Place it at the top of the module. Regards, Greg -----Original Message----- Is there an easy way to make the controls the same height and width with a single operation on the group? Also, is there a way to select a group of controls such as Option buttons and align them together on the left without having to align the individual controls one by one? Thank you in advance. . |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
ActiveX Controls | Excel Discussion (Misc queries) | |||
Tab between ActiveX controls | Excel Discussion (Misc queries) | |||
ActiveX controls | Excel Discussion (Misc queries) | |||
ActiveX Controls | Excel Discussion (Misc queries) | |||
ActiveX Controls vs Form Controls | Excel Discussion (Misc queries) |