View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Orf Bartrop Orf Bartrop is offline
external usenet poster
 
Posts: 21
Default Setting the focus

I have created a spreadsheet requiring data to be entered in a set
order. By that I mean the first entry will be in the first blank cell in
column "B".
On pressing "Enter" I want the focus to move to C, D, E, F then M, N and O.
Two questions:
How do I get Excel to open with the focus in the first blank cell in
column B?
How do I set the movement of the focus on pressing "Enter"?
The cells between column F and M are calculated cells and do not need to
be selected. The cell in column A has the date automatically calculated
when data is added to cell B, C or D.
Please make your reply simple for me to follow as I am rather ignorant
as far as VB is concerned.

Orf