The Point of Grouping

[Gordon Bentley-Mix at news.microsoft.com]

This might seem like a bit of a simple question from an MVP and I could
probably post "somewhere else" and save myself a bit of potential
embarrassment, but I reckon there might be others who have the same question
and would be enlightened by the answer.

Just what exactly is the point/advantage of 'grouping' controls on a
UserForm? (Select multiple controls, right-click, Group.)
--
Cheers!

Gordon Bentley-Mix
Word MVP

Please post all follow-ups to the newsgroup.

Read the original version of this post in the Office Discussion Groups - no
membership required!

 

[Doug Robbins - Word MVP on news.microsoft.com]

Hi Gordon,

One purpose is in the case of radio buttons where those that have the same
group name will be mutually exclusive and will not be affected by the
clicking of radio buttons elsewhere on the form if those radio buttons have
a different group name.

For other controls, the Tag attribute is more useful as you can access it
via code to set common attributes for all controls with the same Tag (For
example setting the Visible or Enabled state)

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

"Gordon Bentley-Mix at news.microsoft.com"

 

[Jay Freedman]

This might seem like a bit of a simple question from an MVP and I could
probably post "somewhere else" and save myself a bit of potential
embarrassment, but I reckon there might be others who have the same question
and would be enlightened by the answer.

Just what exactly is the point/advantage of 'grouping' controls on a
UserForm? (Select multiple controls, right-click, Group.)

It's the same as grouping drawing objects on a document -- select several
controls, group them, and then you can drag the whole group to another position
without losing the relative positioning of the items.

Also, if you're creating a userform with many instances of the same set of
controls, say a text box and a spinner, you can group them, copy and paste as a
group, and then align the groups.

 

[Gordon Bentley-Mix on news.microsoft.com]

Thanks Jay. That's what I suspected: it pretty much does nothing terribly
useful. Explains why I've been able to get along without using it for so
long. I just happened to spot it on the shortcut menu today and remembered it
being mentioned in the (very basic - pun intended) VBA course I took at the
local polytech ages ago. I couldn't recall what it did and thought maybe I
was missing something important. Apparently not... ;-P
--
Cheers!

Gordon Bentley-Mix
Word MVP

Please post all follow-ups to the newsgroup.

Read the original version of this post in the Office Discussion Groups - no
membership required!