How can I use VB to enforce the following data entry controls in Excel 2007 cells? I want to use VB instead of data validation in data tools so pasting of invalid data from other sources won't overwrite the control.
B4..C10: Uppercase first char and no spaces
D4..D10: Lowercase first char and no spaces
Btw, I'm already enforcing correct email address formats with the code in this post http://www.mrexcel.com/forum/showthread.php?p=3042648#post3042648, so want to ensure I know how to use solution to above in conjunction with the email address code.
Thanks.
B4..C10: Uppercase first char and no spaces
D4..D10: Lowercase first char and no spaces
Btw, I'm already enforcing correct email address formats with the code in this post http://www.mrexcel.com/forum/showthread.php?p=3042648#post3042648, so want to ensure I know how to use solution to above in conjunction with the email address code.
Thanks.
