Form Control List Box problem with listcount

[sthiru]

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 Pope]

You need to use the ControlFormat object of the shape in order to get to the usual List properties

Please Login or Register  to view this content.

[sthiru]

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 Pope]

Well what have you tried so far?

[sthiru]

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 Pope]

Before you go any further with this you know Form listbox does not have multiple columns?

[sthiru]

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.

[sthiru]

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

[Andy Pope]

Not on the work sheet.

Depending on the content of the listbox you could concatenate the text per row.