Create a command button with code

[kotzo]

Hi,

Is it possible to create a command button with code (during the macro execution) ?

I want the following thing:

After pressing a command button in my user form,
another command button should be created (or revealed)
on the same user form.

Thanks in advance,

Kotzo

 

[bensonsearch]

could always have the visible setting to false then make it true in the code. otherwise something like:

Dim button As MSForms.commandbutton

Set button = Me.Controls.Add("Forms.commandbutton.1")
With button
.Top = dsa
.Left = asd
.Height = 25
.Width = 1
.Caption = ""
.BackColor = &H0&
End With

 

[kotzo]

Hi bensonsearch,

Thanks for your advice !!

Kotzo

 

[Marcelo Branco]

Using the Visible property, something like

Private Sub UserForm_Initialize()
    Me.CommandButton2.Visible = False
End Sub
 
Private Sub CommandButton1_Click()
    UserForm1.CommandButton2.Visible = True
End Sub

HTH

M.

 

[bensonsearch]

Hi bensonsearch,

Thanks for your advice !!

Kotzo

no problems. the visible setting is easier though