Data Validation - E-Mail Addresses

[Bigmal70]

I am trying to set up a registration form that can be completed in Excel with multiple delegates being registered on a single sheet and have a couple of things that I would like to do but do not know how to do them.

1) There are certain 'mandatory fields' that need to be completed (marked with an asterisc) and I need the users to be prompted if they have not completed these fields.

2) I also need to validate some of the data fields to eliminate as many data entry errors as I can and would like to verify to format of e-mail addresses. This would simply be a case of looking for @ and at least one full stop/period in the data.

I have looked at the various options within data validation and I cannot see a way of doing these so I feel that a macro is my only choice. My only concern is how do I get the macro to run automatically so that the users cannot submit the file to me without any errors/omissions being corrected?

[martindwilson]

data validation of
=AND(ISNUMBER(SEARCH(".",A1)),ISNUMBER(SEARCH("@",A1)))

[martindwilson]

forum is double posting replies again!

[Bigmal70]

Thanks Martin

Any ideas on the mandatory fields?

[martindwilson]

nope not really nothing you can do to make someone fill them in without vba.well there is this but its beatable by copy/paste
just put 0 in a1

[6StringJazzer]

I agree with martindwilson. I solved a problem like this with VBA in another thread.

http://www.excelforum.com/excel-gene...ingencies.html

The user is not allowed to close the file until all required fields are filled in. However, the user must permit macros to run, so you can't absolutely force it.