If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
Hightlight cells that contain special characters
On Tue, 9 Feb 2010 13:45:01 -0800, Gareth_Evans (InterCall EMEA)
m wrote: Stefi, Gord and Ron - thank you all so much for your replies. This has inspired me to learn VBA properly and write a script that will help one of our teams even more. With this sheet I plan to have the cells which contain anything other than A-Z/0-9/space/Hyphen/' show in red. Cells in certain columns which can only have a max amount of characters highlight in blue, an email validation check (for basic format) showing in red also and to turn all cell contents into 'Case Text'. I've even got my workbook to close without giving the user an option to save changes!! I know this is all basic stuff to the pro's but I was so impressed Thanks again and, if anyone reads this and can recommend helpful reference material/books for a beginner I'd love to hear from them. Very best regards, Gareth Glad to help. Thanks for the feedback. Hopefully, one of the others will have some references for you. --ron |
#12
|
|||
|
|||
Hightlight cells that contain special characters
Thanks for the feedback.
As far as books go.................. See Debra Dalgleish's site for a list of books. http://www.contextures.on.ca/xlbooks.html Under Functions, anything by John Walkenbach Under VBA, any of the first three listed and any other by John Walkenbach. Also Reed Jacobsen books are generally pretty good in my experience. Gord Dibben MS Excel MVP On Tue, 9 Feb 2010 13:45:01 -0800, Gareth_Evans (InterCall EMEA) m wrote: Stefi, Gord and Ron - thank you all so much for your replies. This has inspired me to learn VBA properly and write a script that will help one of our teams even more. With this sheet I plan to have the cells which contain anything other than A-Z/0-9/space/Hyphen/' show in red. Cells in certain columns which can only have a max amount of characters highlight in blue, an email validation check (for basic format) showing in red also and to turn all cell contents into 'Case Text'. I've even got my workbook to close without giving the user an option to save changes!! I know this is all basic stuff to the pro's but I was so impressed Thanks again and, if anyone reads this and can recommend helpful reference material/books for a beginner I'd love to hear from them. Very best regards, Gareth |
#13
|
|||
|
|||
Hightlight cells that contain special characters
You are welcome! Thanks for the feedback!
I'd suggest to make use of macro recording, I found it a very useful mean - together with reading Help - when learning VBA. -- Regards! Stefi „Gareth_Evans (InterCall EMEA)” ezt *rta: Stefi, Gord and Ron - thank you all so much for your replies. This has inspired me to learn VBA properly and write a script that will help one of our teams even more. With this sheet I plan to have the cells which contain anything other than A-Z/0-9/space/Hyphen/' show in red. Cells in certain columns which can only have a max amount of characters highlight in blue, an email validation check (for basic format) showing in red also and to turn all cell contents into 'Case Text'. I've even got my workbook to close without giving the user an option to save changes!! I know this is all basic stuff to the pro's but I was so impressed Thanks again and, if anyone reads this and can recommend helpful reference material/books for a beginner I'd love to hear from them. Very best regards, Gareth |
|
Thread Tools | |
Display Modes | |
|
|