Application.WorksheetFunction.Proper(Put string variable here)

"tweety127" wrote:


hi experts....

i just want to ask....

how can i use the PROPER function in macros?....because i want to
automatically change those text not in PROPER case as soon as i click
anywhere on the worksheet...only columns C and D will be
affected...thanks a lot...


--
tweety127
------------------------------------------------------------------------
tweety127's Profile: http://www.excelforum.com/member.php...o&userid=34673
View this thread: http://www.excelforum.com/showthread...hreadid=551002