I've a 2 col multicolumn listbox. Col1 holds values
code has taken from the workbook. Col2 values
are the result of user input into a textbox.

Col1 values have been used to name sheets in a
new workbook

The Col2 values will be used to rename the
respective Col1 named sheet.

As I see it, before user leaves the form, I will
need to check Col2 as follows
:
a) that all entries are filled
b) that all values are valid
c) that all entries are unique
.....that's all I can think of.........?

User exits the form with 'Cancel' or 'Ok' buttons.

Where can I learn something of these techniques
please?

Regards.



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.515 / Virus Database: 313 - Release Date: 01/09/2003