Far behond me......but thanks for the short and to the point answer.

Terry
"Gordon" wrote in message
...
"Terry" wrote in message
...
No thanks...do not wish to use any formulae for this task, as I stated I
wish to be able to select single or multiple text entries, then have an
OPTION to change the case to whatever I need.

Terry

You have two options.
1. Write some VBA and assign a button to it, or,
2. Re-design Excel.