View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JP[_4_] JP[_4_] is offline
external usenet poster
 
Posts: 897
Default Dim item As ListItem

What object library is ListItem from? Do you have a reference set to
its object library?

--JP

On Sep 24, 11:17*am, Gustaf wrote:
Hi,

I get an error on line 2 in this code:

* Dim item As ListItem
* item.Text = product.Name
* ListBox1.AddItem item
* products.Add product, product.Name

The error is

* Object variable of With block variable not set

For some reason, the ListItem object won't let itself be instantiated:

* Dim item As ListItem
* Set tem = New ListItem *' Compile error

My idea is to first instantiate a ListItem, set some properties to it and THEN add it to the ListBox. Why doesn't that work?

Gustaf