Showing error on the program as lnvalid listbox property value

  • Hi all,

    The following program shows as error on invalid property value. i tried out but cant find the exact error in that. I have to search the value in column x and have to display the value with that column R in the listbox.

  • Try changing


    Code
    Me.ListBox1.List(ListBox1.ListCount - 1, 24) = Sheet2.Cells(i, 18).value

    to this


    Me.ListBox1.List(ListBox1.ListCount, 24) = Sheet2.Cells(i, 18).value

Participate now!

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