Thread: OnKey
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
HERNAN HERNAN is offline
external usenet poster
 
Posts: 103
Default OnKey

I have a sheet with 3 cols by 40 rows, where the 1st col is for date, 2nd for
initials, and 3rd for comments. The comments can go for 80 chars at the max
on one line. Then I would like to press resturn just to go down one row on
the same column and continue the comment, etc. If SHIFT-RETURN ( OnKey+~) is
pressed then the cursor should jump DOWN 1 row and LEFT twice.

( If Onkey = "+~" then {DOWN} {LEFT} {LEFT} Else {DOWN})

How can I accomplish that in VB?

TIA

Hernan