Ctrl + lower case ell is shortcut for create list.

Try Ctrl + Shift + ell


Gord Dibben MS Excel MVP

On Thu, 9 Dec 2010 10:44:49 -0800 (PST), Andrew
wrote:

Hello,
I have a macro which is intended to open a userform and populate a
drop down box. I have assigned CTRL L as the keystrokes to run this.
If I run the macro using the keystrokes, the userform does not get
populated. If I run the same macro from the ribbon, the macro works
fine. What might be causing this?

thanks