View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
K.Parker K.Parker is offline
external usenet poster
 
Posts: 5
Default How to change case automatically in Excel

Hi all,

I would like to ask:
How to automatically change the first letter of entry to upper case.
That is:
abc -- Abc
I know I can use a function "Proper", however, how can I change the entry once I press enter?
Do I need to write Macro or VBA?
I am very weak in writing Macro manually.

Please help, thanks all.

K.Parker