Excel 2010; Form Controls: Assign keyboard shortcut to list box

[DavidRoger]

Hi all,

I can assign keyboard shortcut to spinner button and button since it is allowed in the configuration.

I would like to know if there is code which allowed keyboard shortcut to a list box.

If possible, I would like to assign the up and down key to the list box.

Tired of using mouse, target and clicking all over the spread sheet.

As always, helps are appreciated.


I get this from record a macro

Please Login or Register  to view this content.

I have problem integrating into the macro. I can't record a up or down key.