Using ListBox Move and Delete Data

  • Hi All,

    I am working on a user form using a ListBox called ListBox1 and TextBox called TextBox10 and a command button called cmdArchove

    ListBox1 contains 11 columns of data which is sourced from sheet1 A2:K

    The idea is to use TextBox10 to search ListBox1, then use multiselect to chose employee items to archive in sheet4 and deleting from source sheet1.

    the data in column 11 is a unique reference number for the row of data.

    Can anyone help with a code to enable this to happen?

    Many thanks in advance.


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!