Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
To find rate of each item from item.xls and to copy price.xls | Excel Discussion (Misc queries) | |||
Return ListItem via HitTest | Excel Programming | |||
Item numbers result in item description in next field in Excel | Excel Worksheet Functions | |||
Problem with ListItem Width | Excel Programming | |||
disable listitem | Excel Programming |