Error 424 Object required when adding items to multi-column listbox

Hi. I'm trying to add data for the second and third columns of a multi-column listbox. The code as shown below works fine; only the first column is added. When I uncomment the two commented lines I get the 424 error message on the first now uncommented line.

This code is in a UserForm which has two controls: txbLocation and ListBox1. A location is entered into the textbox and matched against entries in column 2 of shtTrailers. When found, items from Column 1, 3, and 4 are to be added to ListBox1.

I'm really puzzled over this. Your guidance is sincerely appreciated. Thanks!

Please Login or Register  to view this content.

How about

Please Login or Register  to view this content.

Nope, same error message. And it doesn't address the error message issue of 'Object required.' Isn't ListBox1 an object? And clearly stated in "With ListBox1"? And which works with .AddItem?

Forgot to remove the .Value from the end

Please Login or Register  to view this content.

Of course. Thanks so much!

You're welcome & thanks for the feedback.