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

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

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
|
|