creating controls using code

[ashishprem]

Hi,
I have created a user form in excel. I want to make checkbox
dynamically when a user presses a comand button. Can anyone please help
me out.
Regards,
Ashish

 

[S. I. Becker]

Hi,

I have created a user form in excel. I want to make checkbox
dynamically when a user presses a comand button. Can anyone please help
me out.
Regards,
Ashish

Your best bet is not to create the control dynamically, but for it to be
there already but invisible and make it visible when the button is pressed.
Add the checkbox to the form and set its Visible property to False. Then
add this line to the button's Click event:

Checkbox1.Visible = True

Obviously, replace "Checkbox1" with the name of your checkbox.

HTH,

Stewart