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:

sub refresh ()
ActiveWorkbook.RefreshAll
Me.listrange= RAW!AA11:AJ11

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