>I want to force the user input in a text box to be uppercase alphanumeric - that is any combination of uppercase numbers and letters. When I use .Format = !A numbers are excluded. Is there an easy way to do this?
>
>TIA - Bob Alei
Bob,
Probably cannot be done in format. But in interactivechange() you can put the line ".value = UPPER(.value)" which should accomplish what you want.
regards,
Jim Edgar
Jurix Data Corporation
jmedgar@yahoo.comNo trees were destroyed in sending this message. However, a large number of electrons were diverted from their ordinary activities and terribly inconvenienced.