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