View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
scott56hannah scott56hannah is offline
external usenet poster
 
Posts: 51
Default Clear Method not working for a ListBox clear

Hi,

I have the following code and I am trying to clear the values in a ListBox...

If ActiveCell.Offset(i, 0) = "" Then
VendorEntry_1280x1024.RuleListBox.Clear
Exit Sub
End If

When the routine is executed it returns the following error message

Run-time error '-2147467259 (80004005)

Unspecified error.

The routine does not continue or recover...can anyone assist with this one ?

Thanks
Scott