I got a problem for dynamically creating listboxes. I am creating
listboxes dynamically through VBA in Excel. Sometimes they are working fine. But
sometimes I couldn't select items in the listboxes. I need solution very urgent.
It could be better if I get it in an hour.

The code I wrote to create is

Sheet8.ListBox1.Copy
Sheet8.Paste Sheet8.Range(strLoc & "23")
Sheet8.OLEObjects("ListBox2").name = "life_Div" & intPlanNo
Set objList = Sheet8.OLEObjects("life_div" & intPlanNo).Object
objList.BringToFront = True