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.

What is ransomware and how do I protect my PC from WannaCry?

Disney layout supervisor Rob Dressel on the challenges of visualising Moana

Siri vs Google Assistant