Activate list box

[Aland2929]

I have a macro that goes to a sheet that contains an Active X List box. I would like the list box to be activated when I access the worksheet so I can use the arrow keys to scroll down but the code below does not allow that? I have to first click inside the drop-down list and then can use the arrow keys.
Thanks in advance.

Please Login or Register  to view this content.

[Olly]

It works for me.

Check you haven't inadvertently disabled events...

[Aland2929]

Thanks for your reply - where would I check if events have been disabled?

[Aland2929]

When I disable the code below, then the list box works as it should so the code below is causing the problem (DisplayFullScreen?). Is there any code I can use to fix it?
Thanks in advance

Please Login or Register  to view this content.

[Olly]

In the immediates pane of the VBE, enter:

Please Login or Register  to view this content.

[Olly]

Just saw your "ScreenUpdating" post.

try removing those lines - does it then work as you want?

[Aland2929]

It works fine if I remove those lines of code but I would like to use that code, if possible?

[Olly]

Then you could change your GoToFC code:

Please Login or Register  to view this content.

[Aland2929]

Thanks so much - works perfectly!