Listbox created with VBA - properties not available

[kt1978]

Hi

Strange problem with this.

If I create a listbox from the control toolbox via vba, The options for 'View Code' and 'Properties' are missing when I right click.

I have tested this with 2010 and 2002 versions. With 2010 it is fine. The problem is only 2002 version. Trouble is i need to use 2002 version for work.

Here is the code.

Please Login or Register  to view this content.

If I create the listbox manually it is fine...

Any ideas.

Thanks

[Andy Pope]

Do you really need the context menu items?

Can you not use ALT+F11 to go to vbe and open the worksheet object.

[kt1978]

Do you really need the context menu items?

Can you not use ALT+F11 to go to vbe and open the worksheet object.

Hi Andy

From your reply, I presume I don't but I was just concerned that it was not working as expected.

I didn't notice at first the when you go to the worksheet object it will appear in the dropdown box so I can still add code the same as before.

Question answered, even if only reassurance that I'm not doing something wrong.

Thanks

[snb]

Besides:

Please Login or Register  to view this content.