Simulating the ALT+DOWN ARROW shortcut

**ElmerS** · 03-31-2009, 06:21 AM

Hi,

I came up with the hereunder code.

Please Login or Register  to view this content.

I am trying to open (to present the drop-down values), via code with: SendKeys "%{DOWN}" command, to simulate the ALT+DOWN ARROW combination - but, unfortunately, it does nothing.

Any help will be appreciated.

Thanks, Elm

**Ron Coderre** · 03-31-2009, 08:06 AM

Your code works fine in Excel 2003.
Have you tried using the code in a new workbook to make sure
the problem isn't restricted to the current one?

**ElmerS** · 03-31-2009, 08:13 AM

Thanks for your reply.

I am using "Excel 2003".

It seems strange that it does not work here.

Do I have to configure something, in "Excel"s configurations to force it work for me ?

Elm

**DonkeyOte** · 03-31-2009, 08:17 AM

It works for me in 2007 too (though renaming the macro is a good idea given ELM1 is a cell reference in 2007), if you're stepping through the code using F8 and/or running directly from VBE it won't....

**ElmerS** · 03-31-2009, 08:23 AM

Thanks DonkeyOte,

You grabbed out something that was left deep in my "memory".

Whenever one tries to rum the code from within the VBE Window - all the Sendkeys are executed in the VBE Window and NOT in the sheet.

Thanks a lot.

Elm