HI.

I have two ListBox(ListBox1&ListBox2) in Worksheet1. The amount of
items of ListBox2 depends on the choice of items in ListBox1.

On Worksheet2, I build a

Private Sub ListBox1_Click()
On Error Resume Next
With ListBox2
.ListFillRange = Range("DetailInfoAddress").Value
End With

End Sub


I mapped the cells relationship between ListBOX1 and ListBOX2 through
the property"LinkedCell". The DetailInfoAddress is the name for one
cell in worksheet2. It stands for a range info
like:Worksheet2!$B$15:$B$17.

However,this VBA program couldn't display the Items in the ListBox2.

Could you Fix this program for me?Thank you in advance!!!

Regards

Sam