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