Database Population Validation Help

[banjoflanjo]

Hi,

I have a cell with the named range “Form1”. This cell is used to populate a database and would normally contain a project number in the format C1234567, where it always starts with a capital C followed by 7 numbers. What I want to do is this, before I run my macro to populate the database, I want the code to check that the letter C entered in “Form1” is in fact upper case, if it is not then I want it to change it to upper case and then continue.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
Also, just as an extra validation I would like it to check that the first letter is in fact the letter C, if it is not I would like to display a message like “This project prefix is ‘x’ rather than ‘C’, please double check your project number and try again.”
<o></o>
Does that sound do-able?
<o></o>
Thanks
<o></o>
Banjoflanjo

 

[banjoflanjo]

And of course if I can also get it to validate the fact that the text string contains 8 characters in total (1 letter, 7 number) where it shows the message "All project numbers should be 8 characters long eg. C1234567. Please check your project number entered and try again." That would be an added bonus!