Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
keyboard up/down arrows to select items in this list box
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
keyboard up/down arrows to select items in this list box
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Pre-Select items in Multi-Select List on Form | Excel Programming | |||
select cells in dropdown list by keyboard | Excel Discussion (Misc queries) | |||
Keyboard Arrows | Excel Worksheet Functions | |||
how to select cells with keyboard if the arrows don't let you go out of the formula | Excel Worksheet Functions | |||
Listbox Select items with Keyboard. | Excel Programming |