ListBox != Forms.ListBox.1?

[briandavid78]

Why doesn't this work:

Please Login or Register  to view this content.

This code generates a "Type Mismatch" error. So instead I try this:

Please Login or Register  to view this content.

That code generates an "Invalid Argument" error (-2147024809...)

I can get a little closer by not declaring the variable lb, like this:

Please Login or Register  to view this content.

But then lb is always Null.

What the heck is going on here?! It seems I can create the ListBox successfully but can't address it after creation?

Little help?!

[Bishonen]

Please Login or Register  to view this content.

[briandavid78]

Hello, Bishonen

The code you posted results in lb as a Null object in the Watch window, which is very very strange because I can still assign properties to it and interact with it as if it were an actual ListBox!

I don't know why it works, but it does and that's good enough for me. Thanks!

-Brian

[Norie]

Brian

Declare as MSForms.Listbox.