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

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

Sub Macro2()
'
' Macro2 Macro
'

'
    Application.MacroOptions Macro:="Macro1", Description:="", ShortcutKey:= _
        "B"
End Sub

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