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.

"Terry" wrote
Far behond me......but thanks for the short and to the point answer.
....
"Gordon" wrote
....
1. Write some VBA and assign a button to it,

Ah, no need to write, just source and use what others have written, giving
due credit, of course. See one way where the entire lot has been packaged
nicely <g in my response in the other thread ..
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----

Thank you
"Max" wrote in message
...
"Terry" wrote
Far behond me......but thanks for the short and to the point answer.
...
"Gordon" wrote
...
1. Write some VBA and assign a button to it,

Ah, no need to write, just source and use what others have written, giving
due credit, of course. See one way where the entire lot has been packaged
nicely <g in my response in the other thread ..
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----