ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Pragramatically grouping items on form (https://www.excelbanter.com/excel-programming/425993-pragramatically-grouping-items-form.html)

[email protected]

Pragramatically grouping items on form
 
I'm trying to automate the process of generating a form that will
later be edited by the user. I'm populating the form with controls
and labels, and I'd like to be able to group each control with its
corresponding label so the user can drag and drop them as a unit when
they customize the layout of the form. I haven't been able to figure
out how to do this. If the controls were on the active sheet I'd do
something like this (from macro recorder):

ActiveSheet.Shapes.Range(Array("Label1", "TextBox1")).Select
Selection.ShapeRange.Group.Select

How can I do the same thing, but on a userform?

Thanks in advance.

-Craig


All times are GMT +1. The time now is 09:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com