ListBox

T

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
 
C

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
 
M

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