I have a user form with list box at the bottom and when i click in a record in list box i get this error:
run-time error '-2147024809 (80070057) Could not find the specified error
message says: Could not find specified error,
and when click debug goes this part of the code:
and highlight in yellow this part of the code:
hope somebody can help me in this please, just about finishing but I am stuck here.
Thanks.
run-time error '-2147024809 (80070057) Could not find the specified error
message says: Could not find specified error,
and when click debug goes this part of the code:
Code:
Private Sub ContactForm_Click()
Dim say As Long, a As Byte
For a = 0 To 11
Controls("textbox" & a + 1) = ContactForm.Column(a)
Next
Sheets("ContactsInvoicing").Range("A:A").Find(ContactForm.Text).Activate
say = ActiveCell.Row
Sheets("ContactsInvoicing").Range("A" & say & ":L" & say).Select
TextBox15 = ContactForm.ListIndex + 1
and highlight in yellow this part of the code:
Code:
Controls("textbox" & a + 1) = ContactForm.Column(a)
hope somebody can help me in this please, just about finishing but I am stuck here.
Thanks.