MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

PRoblem with Dynamically created listboxes

  Asked By: Nichole    Date: Sep 21    Category: MS Office    Views: 1399

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.Paste Sheet8.Range(strLoc & "23")
Sheet8.OLEObjects("ListBox2").name = "life_Div" & intPlanNo
Set objList = Sheet8.OLEObjects("life_div" & intPlanNo).Object
objList.BringToFront = True



No Answers Found. Be the First, To Post Answer.

Didn't find what you were looking for? Find more on PRoblem with Dynamically created listboxes Or get search suggestion and latest updates.