View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Matt Jensen Matt Jensen is offline
external usenet poster
 
Posts: 113
Default Add Checkbox programatically to form

Thanks Bob
Matt

"Bob Phillips" wrote in message
...
Matt,

Here is a simple example


Set newButton = Me.Controls.Add("Forms.Checkbox.1")
newButton.Caption = "Another Checkbox"

With newButton
.Left = 100
.Top = 50
.Visible = True
End With

End Sub

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Matt Jensen" wrote in message
...
In my form's initialise event I'm trying to programmatically add a

checkbox,
which I wouldn't have thought was too hard, but I just can't get it to

work.
Admittedly I'm using trial and error but it's just not happening.
Anyone able to put me out of my misery please?
Thanks
matt