I have created a form (using a cmd button on the worksheet, VBA) for
adding new customers to a different workbook. is there a way to have
this form open automatically if a customer name (text) that is typed
into a cell is not listed in a specified table in the other workbook?


---
Message posted from http://www.ExcelForum.com/