ExcelBanter - keyboard up/down arrows to select items in this list box

On 09/04/2010 06:43 PM, MikeS wrote:
On 09/04/2010 05:02 PM, shy1162 wrote:
I am using the mouse to select items in a list box. Is there a way to
use the keyboard up/down arrows to select items in this list box too?
I am using excel 2000.

This might be worth a try:

http://www.fontstuff.com/access/acctut11.htm

...select a block of items by clicking on the first one and
shift+clicking on the last one.

Separate non-adjacent items can be selected by clicking on the first one
then control+clicking on the others. Already selected items are
de-selected with control+click.

Also

http://www.eggheadcafe.com/software/...box-event.aspx

Joe posted on Sunday, October 07, 2007

There is a multiselect item in listboxes that can be set.

Indicates whether the object permits multiple selections.

Syntax

object.MultiSelect [= fmMultiSelect]

The MultiSelect property syntax has these parts:

Part Description

object Required. A valid object.
fmMultiSelect Optional. The selection mode that the control uses.

Settings

The settings for fmMultiSelect a

Constant Value Description

fmMultiSelectSingle 0 Only one item can be selected (default).
fmMultiSelectMulti 1 Pressing the SPACEBAR or clicking selects or
deselects an item in the list.
fmMultiSelectExtended 2 Pressing SHIFT and clicking the mouse, or pressing

SHIFT and one of the arrow keys, extends the selection from the
previously selected item to the current item. Pressing CTRL and clicking
the mouse selects or deselects an item.

Remarks

When the MultiSelect property is set to Extended or Simple, you must use
the list box's Selected property to determine the selected items. Also,
the Value property of the control is always Null.

The ListIndex property returns the index of the row with the keyboard focus.