View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
helpwithXL helpwithXL is offline
external usenet poster
 
Posts: 28
Default edit cell by macro

hi OJ,
my problem is that while editing the cell, i want to go to the next
line in the SAME cell when i press enter and not to the next cell (as
the default action of pressing enter key). i can go to next line in
same cell by alt+enter (default again) but i have a specific
requirement in which i have to over ride enter key so that when user
presses enter key , the cursor remains in the same cell but on the next
line.

TIA
regards