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

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

On Dec 9, 3:23*pm, Gord Dibben wrote:
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

Here's what happened. I had copied the workbook and saved it as
another file. Both files were open at the same time, and both files
had the same macros in them. When I called the macro using CTRL + L,
Excel called the macro from the other open workbook, not the one I was
working with. The userform came up as expected but it was the
userform from the other workbook. Once I closed the other workbook,
the program worked fine.