Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Wy am I getting Run time error 91 when trying to add controls to my collection.
Public cntrlclctn1 As Collection Sub thing() Dim lbl As Control Dim txtbx As Control 'Create controls Set lbl = UserForm1.Controls.Add("Forms.Label.1") lbl.Caption = "Label Text" Set txtbx = UserForm1.Controls.Add("Forms.TextBox.1") txtbx.Text = "Text Box Text" 'Add controls to collection cntrlclctn1.Add (lbl) cntrlclctn1.Add (txtbx) UserForm1.Show End Sub |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
You have declared a variable for the collection but you have not actually
created the collection object. So you are trying to add controls to a collection object that as yet does not exist... Add this line... set cntrlclctn1 = new collection -- HTH... Jim Thomlinson "ExcelMonkey" wrote: Wy am I getting Run time error 91 when trying to add controls to my collection. Public cntrlclctn1 As Collection Sub thing() Dim lbl As Control Dim txtbx As Control 'Create controls Set lbl = UserForm1.Controls.Add("Forms.Label.1") lbl.Caption = "Label Text" Set txtbx = UserForm1.Controls.Add("Forms.TextBox.1") txtbx.Text = "Text Box Text" 'Add controls to collection cntrlclctn1.Add (lbl) cntrlclctn1.Add (txtbx) UserForm1.Show End Sub |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Was missing the following:
Set cntrlclctn1 = New Collection Fixed! Thanks EM "ExcelMonkey" wrote: Wy am I getting Run time error 91 when trying to add controls to my collection. Public cntrlclctn1 As Collection Sub thing() Dim lbl As Control Dim txtbx As Control 'Create controls Set lbl = UserForm1.Controls.Add("Forms.Label.1") lbl.Caption = "Label Text" Set txtbx = UserForm1.Controls.Add("Forms.TextBox.1") txtbx.Text = "Text Box Text" 'Add controls to collection cntrlclctn1.Add (lbl) cntrlclctn1.Add (txtbx) UserForm1.Show End Sub |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Try this:
Sub thing() Dim lbl As Control Dim txtbx As Control 'Create controls Set lbl = UserForm1.Controls.Add("Forms.Label.1") lbl.Caption = "Label Text" Set txtbx = UserForm1.Controls.Add("Forms.TextBox.1") txtbx.Text = "Text Box Text" txtbx.Left = lbl.Width + 10 If cntrlclctn1 Is Nothing Then Set cntrlclctn1 = New Collection End If 'Add controls to collection cntrlclctn1.Add lbl cntrlclctn1.Add txtbx UserForm1.Show End Sub RBS "ExcelMonkey" wrote in message ... Wy am I getting Run time error 91 when trying to add controls to my collection. Public cntrlclctn1 As Collection Sub thing() Dim lbl As Control Dim txtbx As Control 'Create controls Set lbl = UserForm1.Controls.Add("Forms.Label.1") lbl.Caption = "Label Text" Set txtbx = UserForm1.Controls.Add("Forms.TextBox.1") txtbx.Text = "Text Box Text" 'Add controls to collection cntrlclctn1.Add (lbl) cntrlclctn1.Add (txtbx) UserForm1.Show End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
UserForm Controls Collection | Excel Programming | |||
Run time error 13 with new Collection | Excel Programming | |||
Collection from Range, tag cells on error | Excel Programming | |||
Create a collection of controls | Excel Programming |