ExcelVBA Move Control into a Frame

If I have textbox1 on a userform, and want to move it into frame1 on the uerform, how do I do this with vba code? I thought it might be as simple as textbox.left = frame1.left, but apparently not.

Hi Josh,
Check this site; it might help you further.

http://stackoverflow.com/questions/563972/adding-controls-to-a-frame-in-an-excel-userform-with-vba

That will work good for adding a new control, how can I modify it to work for an existing control?


Private WithEvents Cmd As MSForms.CommandButton
Private WithEvents Lbl As MSForms.Label

Private Sub UserForm_Initialize()
Set Lbl = Frame1.Controls.Add("Forms.Label.1", "lbl1")
Lbl.Caption = "Foo"
Set Cmd = Frame1.Controls.Add("Forms.CommandButton.1", "cmd1")
End Sub

Private Sub Cmd_Click()
Cmd.Top = Cmd.Top + 5
End Sub

Private Sub Lbl_Click()
Lbl.Top = Lbl.Top + 5
End Sub

how can I modify it to work for an existing control?

At runtime, AFAIK you can't. You would effectively be trying to change the Parent of the control. Either add a new control at runtime, or add a control at design time and make it visible at runtime.

Okay thanks, what I got from that - you cant change the parent of a control, so I learned something new. Thinks it about time to learn another coding language... I have a long way yet to master VBA