Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Highlighting first line in list box
Could someone please explain how to consistently set the first
item in the list box to selected (i.e. highlit) without needing to click on it? I've tried List1.Selected(0) = True and list1.listindex = 0 Both *seemed* to work, but occasionaly fail. Thanks - Kirk PS it's not a MultiSelect listbox. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Highlighting first line in list box
Hi,
Do you put the focus on the listBox ? Regards JY "kirkm" wrote in message ... Could someone please explain how to consistently set the first item in the list box to selected (i.e. highlit) without needing to click on it? I've tried List1.Selected(0) = True and list1.listindex = 0 Both *seemed* to work, but occasionaly fail. Thanks - Kirk PS it's not a MultiSelect listbox. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Highlighting first line in list box
On Mon, 12 Mar 2007 14:33:45 +0100, "Jean-Yves"
wrote: Hi, Do you put the focus on the listBox ? Regards JY Hi JY, Thanks for that suggestion, I've just applied it and not had a failure in 10 or 20 goes. I had assumed the listbox *would* have the focus in it's own Enter event. Private Sub List1_Enter() List1.SetFocus <<<< New line List1.Selected(0) = True End Sub I proved List1.Selected was working as substituting another number for (0) sees the slection change to that line. Why it sometimes didn't work I couldn't figure.... hope this fixes it. Thanks - Kirk "kirkm" wrote in message .. . Could someone please explain how to consistently set the first item in the list box to selected (i.e. highlit) without needing to click on it? I've tried List1.Selected(0) = True and list1.listindex = 0 Both *seemed* to work, but occasionaly fail. Thanks - Kirk PS it's not a MultiSelect listbox. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
highlighting different line in a cell | Excel Worksheet Functions | |||
Vertical Highlighting on line graph??? | Charts and Charting in Excel | |||
Vertical highlighting in line graphs???? | Charts and Charting in Excel | |||
highlighting different sections of a line chart | Charts and Charting in Excel | |||
Highlighting Duplicates in a List | Excel Programming |