Listbox-a way to fill the list box

[walid66]

I have a data in the "A" column and I want this data to fill a list box. the data size is unknown one time could be range from "a2:a30" or sometime from "a2:a120". Is there a way to fill the list box with the data in column A without put changing the code manually see code below.

Please Login or Register  to view this content.

[Tristan]

Hi Walid,

Try the code below. It should automatically find the last cell used in column A so whether you got values in A2:A50 or A2:A3 it should return the right range. It'll need to be tweaked however if you've got anything else in Column A.

Let me know how it goes,

Please Login or Register  to view this content.

Tris

[walid66]

thanks it worked.