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!
