List box selection leading to that selection being removed from the source.

[paul138]

Hi,
Please Help.

I have a list box containing 5 countries: England, Scotland, Ireland, Wales, Germany.....

When the user selects the country, and clicks ok, i want that country to be removed from the RowSource data (Sheet1, Cells C101:C105). However i dont know the code for this.

I dont want any rows to be removed, rather just a clear contents.

Please Help,
Thanks in advance

[Guido Geurs]

Dear,

I hope this will solve your problem (see attachment)


br,