Adding Control to a Dynamic Listbox

Hi,

I'm at the point where I have NO idea on how to continue and would really like a bit of help.

I have a static userform with static buttons. What I currently do is when the userform activates I dynamically add a multipage for each sheet with the corresponding name of the sheet. So if I have 4 sheets named A,B,C & D, I will have a multipage with 4 pages named the same. In each of the pages I dynamically add a listbox. The list box has 5 columns and x amount of rows depending on the amount of rows in the corresponding sheet.

What I am stuck on is how to add the double_click control for each of the listboxes or for that matter any type of control. Each listbox is names ListBox and I know the difference between each one by what page is currently selected.

I will add the sample program that I am working on to sort this out. It may give you a better idea on what I am trying to achieve.

Any help would be great
Thanks
Ben

Hi

Have a look at



http://www.cpearson.com/excel/vbe.htm

It may give you some ideas on how to use code to program code.


rylo

Thanks for that. I have had a look and understand the code to do it but I am having trouble applying it to my code.