Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
NewIndex for ListBox?
How do I get the listindex of the item which is most recently added to the
listbox which is sorted? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
NewIndex for ListBox?
Cool question. Got no steady clue.
Maybe after adding an item to your listbox, store it's value somewhere far away in a cell and call that cell if you need the value again. If you add another more item to the list, just overwrite the cell so it's always update. But that will only work with unique listitems... "OKLover" schreef in bericht ... How do I get the listindex of the item which is most recently added to the listbox which is sorted? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
NewIndex for ListBox?
ListBox1.ListCount
-- HTH Bob Phillips "OKLover" wrote in message ... How do I get the listindex of the item which is most recently added to the listbox which is sorted? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
NewIndex for ListBox?
Whe the Listbox is sorted, the ListBox.ListCount may be not equal to the
'NewIndex' "Bob Phillips" wrote: ListBox1.ListCount -- HTH Bob Phillips "OKLover" wrote in message ... How do I get the listindex of the item which is most recently added to the listbox which is sorted? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
NewIndex for ListBox?
No, but it is before you sort it.
-- HTH Bob Phillips "OKLover" wrote in message ... Whe the Listbox is sorted, the ListBox.ListCount may be not equal to the 'NewIndex' "Bob Phillips" wrote: ListBox1.ListCount -- HTH Bob Phillips "OKLover" wrote in message ... How do I get the listindex of the item which is most recently added to the listbox which is sorted? |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
NewIndex for ListBox?
Or even ListCount + 1 before you add it.
-- HTH Bob Phillips "OKLover" wrote in message ... Whe the Listbox is sorted, the ListBox.ListCount may be not equal to the 'NewIndex' "Bob Phillips" wrote: ListBox1.ListCount -- HTH Bob Phillips "OKLover" wrote in message ... How do I get the listindex of the item which is most recently added to the listbox which is sorted? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
listbox B conditional of input in Listbox A | Excel Discussion (Misc queries) | |||
Equlivelent to .NewIndex Property in VBA Excel ? | Excel Programming | |||
Multicolumn Listbox and ordinary listbox | Excel Programming | |||
listbox.value not equal to listbox.list(listbox.listindex,0) | Excel Programming | |||
Is refreshing listbox rowsource in listbox click event possible? | Excel Programming |