I have a macro that was working fine in Excel 2007, but just upgraded to 2010 and am getting this error:
Run-time error '-2147467259 (80004005)':
Could not set the SelText property. Unspecified error.
The line that it highlights is in a UserForm_activate event handler:
Any ideas? I searched for the error, but it turned up literally nothing!
Run-time error '-2147467259 (80004005)':
Could not set the SelText property. Unspecified error.
The line that it highlights is in a UserForm_activate event handler:
Code:
UserForm1.ListBox1.AddItem ("Item 1")
UserForm1.ListBox1.AddItem ("Item 2")
UserForm1.ListBox1.AddItem ("Item 3")
UserForm1.ListBox1.AddItem ("Item 4")
Any ideas? I searched for the error, but it turned up literally nothing!