running macro from keystrokes versus from ribbon

[Andrew]

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

 

[Gord Dibben]

Ctrl + lower case ell is shortcut for create list.

Try Ctrl + Shift + ell


Gord Dibben MS Excel MVP

 

[Andrew]

Ctrl + lower case ell is shortcut for create list.

Try Ctrl + Shift + ell

Gord Dibben     MS Excel MVP

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.