VBA Listbox problem

  Chas49 11:56 03 Apr 08
Locked

I have a list box containing anything up to 400 items. In order to create a new list in this box I first have to remove the existing items. I have tried (and failed) to use the RemoveItem instruction to clear the list. Clearly I am not coding it correctly, help appreciated in getting the right code, The listbox is named as Listbox2

  VoG II 12:04 03 Apr 08

Try

UserForm1.ListBox1.Clear

  Chas49 12:09 03 Apr 08

That did the job.

Many thanks, both for the solution and the quick reply.

This thread is now locked and can not be replied to.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

This abstract video touches on division in our technologic world

Best alternatives to iTunes for Mac | Best music players for macOS: Free your music from the…