Self student Project - Validation in Excel with Macros

Hi,

I need a detailed guidance for the self project that I do. I am planning to do it with Excel Macros.

Scenario:
Option 1. The users have a application interface where they can key in the data.
Option 2. They can key-in the same details through the excel sheet that I provide as well.

Ex: There are 10 columns and 10 rows in a sheet. I want to validate every column/cell to hold just the format of data that I want.

Assume: Row 1 should always be the header. Details enetered in column A should be a item code(say 1001), column B should only have decimals with no fraction.
Thus the complete (10 X 10) should be validated and the users should not be able to enter anything apart from what format was assigned for that cell. Otherwise it should throw the error and user should make the correction at that moment itself.

When entering the data via the application interface I want all that happens completes it validation at Excel itself and the error should not come outside.(Application Interface Error should not come)

Is it with Macros that I should proceed with or any other option is there?


Thanks for reading with patience. And even the smallest bit of advice/guidance could help me. Has anyone else did similar projects? Please share and guide me.


Thanks,
Sarvi

see the below link for info on data validation....should be half the battle, let us know if you are still having problems

http://www.contextures.com/xlDataVal01.html

thx. dont think i am bumping it up. but a help/explanation on my scenario is highly needed. thanks in advance.

Anyone pls help me on this...

What's being said is to use the native Excel validation routines whenever possible. If you're limiting the imput to only certain entries, maybe all of the appropriate entries can be put into one list and then the selection validated against it. Not only does it ensure that the entries are correct, but it's usually easier for the client to select than to type. So, you should read up on how to validate the data - that's what the URL mentioned above will do. First of all, use what Excel gives you and a macro only when you can't do it any other way.

HTH.

Bob