Automating the Creation of Userforms in VBA
Sounds like a complicated program. Probably be easiest to just create
a dialogsheet instead of userforms.
Set yourDialog = ActiveWorkbook.DialogSheets.Add
Then you can add checkboxes to it like
yourDialog.CheckBoxes.Add
Noel wrote:
I am trying to create a semi-automated system using VBA in Excel and
need some help in creating an interface for user input.
With each use of the tool I am building, it needs to create
automatically a different number of user forms with a varying number
of checkboxes in each one. Not only will the number of user forms
change with each use of the tool, but so also will the number of
checkboxes on each user form. Does anyone have an idea as to how to
do
this?
Thanks in advance....
|