Automatically drop down list when focus on merged cells

[boboivan]

Hi everybody!

I try to automatically drop down the list when I set focus on my merged cells L8:O8 in my sheet.

I use the following code, but it doesn't work.

Please Login or Register  to view this content.

Any idea why?

THX for the help!

[Arkadi]

Hi boboivan, try this:

Please Login or Register  to view this content.

[Kamboj]

Please Login or Register  to view this content.

[boboivan]

Thank you Arkadi!

Works fine, but it seems like it's a problem though with the num lock key.
When I set focus on the range, the num lock turns off.

[boboivan]

Thank you Kamboj!

Arhadi's solution works.

[Arkadi]

boboivan, yes it is a known bug... let me look into it.

[boboivan]

The solution to this problem is to create a module with the following code:

Please Login or Register  to view this content.

After that, the code should look like this:

Please Login or Register  to view this content.

Works like a charm!
Cheers