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.
|