| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ListBox
Hello,
I have ListBox, there are few rows. I just need know which one is select (order number). I tried this: MsgBox ListBox1.ListIndex ... but I quess this is bad. Can you help me. Thanks Tom |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
ListBox
Tom,
What is the problem with the code you used? What error did you get? The ListIndex property will return the 0-based index of the selected item, or -1 if no selection is made. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "TOM" wrote in message ... Hello, I have ListBox, there are few rows. I just need know which one is select (order number). I tried this: MsgBox ListBox1.ListIndex ... but I quess this is bad. Can you help me. Thanks Tom |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
ListBox
TOM:
please check that your listbox's proterty: Is the "multiselect"=1 or 2 ? -- ³ÂÏ£ÕÂ@Öйú *ÇîÇÒ¶ÀÉÆÆäÉí**´ïÔò¼æ¼ÃÌìÏÂ* "TOM" wrote in message ... | Hello, | | I have ListBox, there are few rows. I just need know which one is select | (order number). I tried this: MsgBox ListBox1.ListIndex ... but I quess this | is bad. | | Can you help me. | Thanks | Tom | | |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Listbox 2 takes the value of Listbox 1 | Excel Discussion (Misc queries) | |||
| listbox B conditional of input in Listbox A | Excel Discussion (Misc queries) | |||
| listbox.value not equal to listbox.list(listbox.listindex,0) | Excel Programming | |||
| Is refreshing listbox rowsource in listbox click event possible? | Excel Programming | |||
| Sorting ListBox results or transposing ListBox values to other cells for sorting | Excel Programming | |||
Hybrid Mode
