Hi,

I recently got a project to enhance a new field to restrict some countries from an invoice. For setting up restriction for certain matters, is it better to set a table and list out all of the countries that I want to include, and the one that is left out, then I want to restrict them?

I don't have the data with me because the data will extract out from another database that I don't have access to. My role now is only to put a restriction tool in the form so when the data entry people run the form, it can restrict them from entering data from the countries that is restricted by the company.
PS: since I can't post an attachment on this thread, the restriction data I am planning to have is listed like below, please teach me how I can have the code look up to the worksheet placed on the desktop (later on I will put this file on the share folder with the vba and form). what I want to do is to put a restriction warning if the data entry person enter an restriction country, then it will not help them process the invoice into the database. Please advice.

Countries
India
Nigeria