Confine Cell to Proper Case

  • Thread starter Thread starter igbert
  • Start date Start date
I

igbert

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.
 
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
 
Back
Top