Is there a way to confine a cell for Proper Case without invoking a macro?

i.e.

If I type "enter account number" in cell A1, cell A1 (not any other cell)
should automatically change to "Enter Account Number" without running a macro.

Thanks.

Igbert

You can not change the input to become proper case but you can set another
cell to return the input in proper case. So if you input cell is A1 then in
B1 add the formula =Proper(A1).

Otherwise you can add a custom validation that would require the user to
enter the value in proper case but the users may not be too impressed when
the value they enter is not accepted and they need to retype it.
--
HTH...

Jim Thomlinson


"igbert" wrote:

Is there a way to confine a cell for Proper Case without invoking a macro?

i.e.

If I type "enter account number" in cell A1, cell A1 (not any other cell)
should automatically change to "Enter Account Number" without running a macro.

Thanks.

Igbert

Using event code you can do it automatically in-cell as you enter.

Still uses VBA but you don't have to "invoke" the code.

Without some type of code you will have to use a helper cell with the PROPER
function.


Gord Dibben MS Excel MVP


On Wed, 10 Feb 2010 09:44:04 -0800, igbert
wrote:

Is there a way to confine a cell for Proper Case without invoking a macro?

i.e.

If I type "enter account number" in cell A1, cell A1 (not any other cell)
should automatically change to "Enter Account Number" without running a macro.

Thanks.

Igbert