L
Little Penny
I trying to create a code the will validate my data in a range of
cells:
B55 is a merged cell
And
E8:E18
I want to insure that the user enters data in this format
XL- and a seven digit number that could start with 0
Example XL-0775412
I also want the XL- to always be capitalized.
If user enters invalid data I want a msg box to give them a sample of
the format
I tried use data validation but I could not get it to work.
I think I would have to use some type of worksheet change event
Any suggestions would be greatly appreciated.
cells:
B55 is a merged cell
And
E8:E18
I want to insure that the user enters data in this format
XL- and a seven digit number that could start with 0
Example XL-0775412
I also want the XL- to always be capitalized.
If user enters invalid data I want a msg box to give them a sample of
the format
I tried use data validation but I could not get it to work.
I think I would have to use some type of worksheet change event
Any suggestions would be greatly appreciated.