PDA

View Full Version : UserForm - clear contents for next entry



yn19832
03-30-2007, 04:31 AM
I have an UserForm containing a listbox named "ListCT", and it has two columns. I want to clear all the contents in the listbox for next entry with the following code:

LiqForm.ListCT.List = ""

But it does not work, can anyone give me some advice?

Bob Phillips
03-30-2007, 05:10 AM
LiqForm.ListCT.Clear

yn19832
03-30-2007, 05:27 AM
Many thanks.