Adding Code to Command Button Added At Run Time

[Guest]

I have a poject with a form which has a Command Button, Text Box, and Label
control added to it at run time. It has taken me at least three hours (I'm
extremely new at programming) to figure out how to add the three controls to
my form at run time. Once I finally figured out how to do all that I
realized I didn't know how to add code to make my command button do
something. What I want to do is after my form is shown on the screen, the
label presents a question "How many text boxes do you want added to the
screen?". The user will enter the number (1 - 10) in the text box and then
hit ok. The code under that button should then remove the initial Label,
Text Box and Command Button controls, and add the specified number of text
boxes, and resize the screen according to the amount of text boxes added.

 

[Tom Ogilvy]

You would be better off putting everything in at design time.
Then make controls visible or visible = False at the appropriate time

So the code and controls are all in place.

Lets say you have a userform of Height 80 with textboxes already in place
but visible = false. You want to have half visible, so your code loops
through making them visible, then sets the height to 40 to "size" the
userform. The other half of the userform will be virtual - it will be as if
it doesn't exist.

Another consideration is if you try to add code and controls with code, you
won't be able to protect your project.

 

[Guest]

Hi Tom,

I was searching the site for information on a control button and came across
this posting. My question is if I add a control button with code, that will
prevent me from protecting my worksheet and workbook? Is there a work around
for this. Am I left with using a macro on a custom toolbar?

Thank you