Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have an excel vba macro that uses a collection to store some string
data. The collection 'key' is a string that is shown in a listbox. (as below) When accessing the 'Item' property, I get the runtime error: "Object variable or With block variable not set" ' lbFiles is a listbox Dim FileNames_ As Collection Private Sub btn_Click() Dim ListItem As Integer ListItem = GetSelected() If ListItem -1 Then Dim Path As String Path = FileNames_.item( lbFiles.List(ListItem)) 'error here '... End If '... End Sub I noticed that in all the documentation, the 'Item' property is upper case, but if I try to type 'FileNames_.Item' in to vba, it automatically lowers the case. (as above) Does that make a difference? Thanks, Paul |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How does Collection.Item search | Excel Programming | |||
How to assign a collection item? | Excel Programming | |||
Series Collection Results in Runtime Error 1004 | Excel Programming | |||
Retrieving a Collection Item | Excel Programming | |||
Runtime error with the sheet collection, which was not there in 20 | Excel Programming |