Properties/Methods List

[mcbuddah]

Hi, I've been a member for a little while and have lurked around and have found the help here really wonderful.

I have a stupid and hopefully simple question. I searched and could not find anything, maybe I was not searching for the correct terms, not exactly sure.

When I am writing some code for example; Cells.(4,7)
Once I type the dot after "Cells" I receive a list of all the Properties/Methods like "Activate, Add Comment, etc...." that would show me the available choices.

When I add a ActiveX Listbox and I type for example; "Listbox1." or whatever I have named the listbox I don't receive this handy list that shows me the available choices. When my co-worker and I create the exact same sheet with the exact same code and object he receives this list.

Any thoughts as to why this would occur?

[romperstomper]

Are you definitely typing in the code module for the worksheet, not a normal module (or a different sheet's module)

[mcbuddah]

I am typing the code in the worksheet module, I have only 1 sheet in this file.

[romperstomper]

Assuming you have the name right (try starting with Me. just to make sure) does pressing Ctrl+J after typing the full stop work?

[mcbuddah]

Ok, so typing Me. provides the list of choices. Pressing Ctrl+J after the full stop does not work when I type in the name of the listbox. I checked to make sure that I am typing the correct name of the listbox to be sure, and I am. I just have this feeling I'm making a horribly simple and embarrassing mistake somewhere here.

[romperstomper]

When you typed Me. did Listbox1 appear in the list of choices? If not, then the control name is wrong.

[mcbuddah]

Yes, ListBox1 showed up in the list of choices.

[romperstomper]

So if you type Me. then select Listbox1 from the list, then type . nothing happens?

[mcbuddah]

So if you type Me. then select Listbox1 from the list, then type . nothing happens?

Exactly, once I type . nothing happens

[romperstomper]

Do you have a reference set to the Forms object library? (it should have been added automatically when you put the control on the sheet)

[mcbuddah]

I believe so. I have Microsoft Forms 2.0 Object Library selected. To be honest I wouldn't know if this would be the correct reference or not.

[romperstomper]

That is the correct one.
I am stumped as to why it doesn't work for that control. What if you add another control - does the autolist work for that one?

[mcbuddah]

Ok I added a check box, and the same result. Also tried a command button, still no luck.

[romperstomper]

I just can't replicate that. If it works for the Me keyword, then it should work for the Objects assuming the reference is OK, which it seems to be.

[mcbuddah]

Yeah, my co-worker can't seem to replicate this either. I looked through the 'Options' in the Developer tab and didn't see anything that would affect this.

[romperstomper]

The options are all-or-nothing, so if you get the list with one, you should get it with the other, unless there's a reference issue (and hence the VBE doesn't know what the options are). Are all your forms behaving normally?
I even tried disabling all ActiveX controls in the Trust Center but that made no difference.

[mcbuddah]

As far as I can tell the other forms are working as intended. The interesting part of this is if I type ListBox1.Text and have the output attached to a MsgBox it works correctly. I just never get prompted with the list of choices, but if I type one of them in then it will function correctly.

[mcbuddah]

Thanks for trying romperstomper, I appreciate the effort.