VBA Listbox problem

  Chas49 11:56 03 Apr 2008
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 2008

Try

UserForm1.ListBox1.Clear

  Chas49 12:09 03 Apr 2008

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.

Elsewhere on IDG sites

Galaxy Note 8 vs iPhone X

Awful clip art from 1994 is being tweeted every hour by a bot

iPhone X vs Samsung Galaxy Note 8

Les meilleurs navigateurs internet 2017