Form Control List Box problem with listcount

Hi Everyone

I'm trying to change "activex control listbox" to "form control list" box but I can't able to perform some vba operations. Such as listcount...etc and below is my code for activex listbox and I need to change it to form control list box. Name of the list box :List Box 45"

Please assist me

Please Login or Register  to view this content.

Andy thank you so much for your reply but I don't how to modify with my code could you please help me on this.

Please do reply

Thanks
Thiru

Andy

What I have done is I have inputed your code in "UserForm_Activate()" and modified the other command codes with "objLb" for List box(e.g. Sheets("ISIP").objLb.List(Sheets("ISIP").objLb.ListCount - 1, 1) = Sheets("2011").Range("T" & i)

Please help me on this.

Thanks
Thiru

Andy

For your reference i copied entire code - Note the form list box is in sheet ISIP

Please Login or Register  to view this content.

I there any other way that I can use multiple column as like listbox - what I meant is anyother controls other than activex.