mmtraining
IS-IT--Management
Is there any way of testing whether there is an AutoText with a certain name, apart from picking up the error number if it is not there?
We have got thousands of bits of AutoText which have numbers as names. If someone types a wrong number into a field I want to give that person a better error message than the possibility of testing or ending the macro.
The more I think about it, the more I think the best way is to do an ON ERROR GOTO SOCK and then read out the error number. Has anyone got a better idea?
TIA
Carol
Berlin, Germany
We have got thousands of bits of AutoText which have numbers as names. If someone types a wrong number into a field I want to give that person a better error message than the possibility of testing or ending the macro.
The more I think about it, the more I think the best way is to do an ON ERROR GOTO SOCK and then read out the error number. Has anyone got a better idea?
TIA
Carol
Berlin, Germany
