View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default Listbox Index Problem

Todd,

LstBxItem is just a index variable, it doesn't have a value property. What
are you trying to show with the second MsgBox, as it seems you are trying to
show the same thing to me. If you want the in dex itself, just use

Msgbox LstBxItem

maybe plus 1 if yhou don 't want it starting at 0

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Todd Huttenstine" wrote in message
...
With Worksheets("Wkly Renewals").ListBox1
For LstBxItem = 0 To .ListCount - 1
If .Selected(LstBxItem) Then
MsgBox .List(LstBxItem)
MsgBox LstBxItem.Value
end with
When it hits the line MsgBox .List(LstBxItem) it displays
the value. In this case its index item 0 so it displays
the index item 0 which is the value "Jan Week 1" When it
gets to the MsgBox LstBxItem.Value line, I get the error
Runtime error 424 object required.

Why is this?