how to set row source/List fill range for ActiveX control Listbox via VBA code.

Hi guys,

I have table from AA11 to AJ11, that table is continuously updating depending on the data coming from SQL.
Im trying to capture all the data from the table and place it on my existing ActivexListbox.
the problem im experiencing is the list fill range i declared is questionably changing after several file refresh.

im thinking of a code that will declare what specific List range for my activeXlistbox1 after the refresh.

something like:

Please Login or Register  to view this content.

I don't know how to deal with activex listbox.
advance thank you.

no matter how many records in your table, the form load will load all iems from the updates.

Please Login or Register  to view this content.

can you explain how it works? Im trying to declare the List range via VBA

sorry, the exact List range should be: RAW!AA11:AJ100

thank you

Hi Norie,

since im pulling data from SQL, the table could have different number of data.
so I only set that range (AA11:AJ100 ) to capture into my listbox.
so the logic is just to display it in my listbox.