Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
creating a function
I would like to create a function or soemthing that checks to be sure the
length of a certain cell is 5 characters, no more or less; whenever the user leaves that cell. It can be if they hit the "enter" key, or an arrow key, etc. The other thing I need to do is to write this function (or whatever) in a new spreadsheet / workbook. My macro is going to check for a specific file name and if that file is not found, it will create the file. However, the new file has to have the same capabilty to check that certain cell for 5 characters. Any suggestions on how this could be accomplished would be appreciated. Thanks for the help.......... -- JT |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
creating a function
You can use Data Validation from the Data menu to restrict text
length to 5 characters. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "JT" wrote in message ... I would like to create a function or soemthing that checks to be sure the length of a certain cell is 5 characters, no more or less; whenever the user leaves that cell. It can be if they hit the "enter" key, or an arrow key, etc. The other thing I need to do is to write this function (or whatever) in a new spreadsheet / workbook. My macro is going to check for a specific file name and if that file is not found, it will create the file. However, the new file has to have the same capabilty to check that certain cell for 5 characters. Any suggestions on how this could be accomplished would be appreciated. Thanks for the help.......... -- JT |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need help creating a function | Excel Worksheet Functions | |||
Creating a Function | Excel Worksheet Functions | |||
Creating a Function | Excel Worksheet Functions | |||
Need help creating a function | Excel Discussion (Misc queries) | |||
Creating a Function | Excel Programming |