View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Nigel Nigel is offline
external usenet poster
 
Posts: 923
Default Fill cell on exit?

This will do it, but note detecting the direction of movement is not
possible, so moving down or up the column will result in the value in the
cell above changing. Set the Colum number you require this act on (where A=
1; B=2 etc)

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
if Target.Column = 1 then Target.Offset(-1, 0) = "/ ??"
End Sub

--
Cheers
Nigel



"PG Oriel" wrote in message
...
Hi,

Is it possible to have a cell selected, as in, just the black box over it,
and then on moving my down on the arrow key for it to fill the square,
with a
/ ??

It is for a teacher's register.

Thanks.