View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
kirkm[_9_] kirkm[_9_] is offline
external usenet poster
 
Posts: 14
Default Looking for an example


To put several controls on a form from code.

Was playing with this but can't get it to work -
---
Private Sub CommandButton1_Click()

Dim myLabel As Label
Set myLabel = frmMyForm.Controls.Add("Forms.Label.1", "lblPrompt")
With myLabel

.Left = 10
.Top = 10
.Width = 30
.Caption = "Enter your name:"

End With

End Sub
---

Thanks - Kirk