Need help to setup restriction (countries) on an already existed VBA

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 be extracted out from another database that I don't have access to. My role 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.

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.

Hi siulonbow

I've posted a rudimentary example of how you can do this. Enter a Restricted Country into the Textbox and press enter or tab out of the Textbox. See if you can work the example into your code.

John

Hi siulonbow

The attached demonstrates

Are there anyway I can have a list of un-restricted countries?

John

Hi siulonbow

Regarding your questions:

How can I tell the user form the location

I don't really understand the question. The location of what? Where to put the UserForm? How to populate the UserForm? Please expand your inquiry.

Is the code going to restrict everything listed in the worksheet?

The code will do what you tell it to do. The code I've provided doesn't to anything. It's merely a demonstration of this

Are there anyway I can have a list of un-restricted countries? Please demonstrate.

should I use a dropbox that have all countries selection

I don't know. How many Unrestricted Countries are there? How many Restricted Countries are there? If you have a dropdown list of 500 countries, that's too much information.

If taking dropbox route, what should I do

Again, I don't know. I have no idea what your process is or how all of this integrates. You need to detail your current process (and share dummy data) and explain how you wish to change the current process. At this point, I can't (and won't) even begin to guess what you're after. I need MUCH more information.

I'll be glad to help if I can. I need a place to start. Only you can provide that.

John

Hi siulonbow
When I unzip your file it creates a file called TB1.sln. I don't know what that is but I can't open it.
John

Hi siulonbow

I'm not familiar with MS VB express. What version of Office are you using (I'd suggest you update your profile to include this information)?

Office 2007 has a built in zip procedure. Right Click the file ->Send To-> Compressed (zipped) Folder.

Beyond that, there are many free Zip programs available on the Web.

John

PS: I guess I should have asked if your file is too large to send as an Excel file

Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!

Read this to understand why we ask you to do this