administration tool

I have a question about something that I do not know if it is possible or
not. The situation is the following: I have a userform that the user uses to
setup a report that my macro is to create. Now the userform functions in the
following way. There is a list with checkboxes, each checkbox belongs to a
chart. If the checkbox is �checked� then the chart shall be displayed in the
report, otherwise it shall not be displayed.

I need to keep everything variable so my macro functions like this. It
counts the number of checked checkboxes in the userform and uses this values
later on in the program. Now I thought about giving the user the possibility
to add or remove checkboxes from the userform. This is done by clicking on a
button that leads to some administrator tool. In that tool the user can
choose the number of checkboxes desired. But that requires that the userform
changes the number of checkboxes also, otherwise the value would not be
correct (the value is very important because I loop everything in order to
keep the code short). Does it make any sense?? If you have any understanding
and you know something about creating some administrator tool for a vba
application please help me out! Thanks a lot in advance!

Arne,
May be a Tree View with checkboxes would be more suitable control ?
Easy to vary the number of nodes.

NickHK

"Arne Hegefors" <ArneHegefors@discussions.microsoft.com> wrote in message
news:D15915B8-0DD2-4231-9BE9-E9F93F4B31CC@microsoft.com...
> I have a question about something that I do not know if it is possible or
> not. The situation is the following: I have a userform that the user uses
to
> setup a report that my macro is to create. Now the userform functions in
the
> following way. There is a list with checkboxes, each checkbox belongs to a
> chart. If the checkbox is "checked" then the chart shall be displayed in
the
> report, otherwise it shall not be displayed.
>
> I need to keep everything variable so my macro functions like this. It
> counts the number of checked checkboxes in the userform and uses this
values
> later on in the program. Now I thought about giving the user the
possibility
> to add or remove checkboxes from the userform. This is done by clicking on
a
> button that leads to some administrator tool. In that tool the user can
> choose the number of checkboxes desired. But that requires that the
userform
> changes the number of checkboxes also, otherwise the value would not be
> correct (the value is very important because I loop everything in order to
> keep the code short). Does it make any sense?? If you have any
understanding
> and you know something about creating some administrator tool for a vba
> application please help me out! Thanks a lot in advance!
>

this code by J-walk shows how to create a userform on the fly:

http://www.j-walk.com/ss/excel/tips/tip76.htm

so you could store the parameters that the user selects and build a dynamic
userform to conform to those parameters. It doesn't appear that you need
events for the dynamic portion of your userform (checkboxes), so this makes
this approach more feasible/easier.

--
Regards,
Tom Ogilvy


"Arne Hegefors" wrote:

> I have a question about something that I do not know if it is possible or
> not. The situation is the following: I have a userform that the user uses to
> setup a report that my macro is to create. Now the userform functions in the
> following way. There is a list with checkboxes, each checkbox belongs to a
> chart. If the checkbox is “checked” then the chart shall be displayed in the
> report, otherwise it shall not be displayed.
>
> I need to keep everything variable so my macro functions like this. It
> counts the number of checked checkboxes in the userform and uses this values
> later on in the program. Now I thought about giving the user the possibility
> to add or remove checkboxes from the userform. This is done by clicking on a
> button that leads to some administrator tool. In that tool the user can
> choose the number of checkboxes desired. But that requires that the userform
> changes the number of checkboxes also, otherwise the value would not be
> correct (the value is very important because I loop everything in order to
> keep the code short). Does it make any sense?? If you have any understanding
> and you know something about creating some administrator tool for a vba
> application please help me out! Thanks a lot in advance!
>