ListBox

[TOM]

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

 

[Chip Pearson]

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

 

[Mike]

TOM:
please check that your listbox's proterty: Is the "multiselect"=1 or 2 ?



--

³ÂÏ£ÕÂ@Öйú

*ÇîÇÒ¶ÀÉÆÆäÉí**´ïÔò¼æ¼ÃÌìÏÂ*



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