Creating Rules

Hi Everybody!

Just a quick one, I have a spreadsheet that Im creating for our department that has lots of data on, and is constantly being updated by different people. I want to create a rule for a column so that whenever text is entered, it automatically configures it to 'PROPER'. I understand the 'PROPER' formula for changing all caps to small caps and vice versa, but want something to make 'A BROWN CAT' into 'A Brown Cat' upon entry.

Is this something that can be done?

Btw, I have average knowledge of formulae and excel, but not of macros if that helps anybody,

Many thanks for any assistance.

Alex

Please Login or Register  to view this content.

This is worksheet event code, which means that it needs to be
placed in the appropriate worksheet code module, not a standard
code module. To do this, right-click on the sheet tab, select
the View Code option from the menu, and paste the code in.