Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Fill cell on exit?
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
remove fill in text from a cell from an unpopulated fill-in cell | Excel Worksheet Functions | |||
How do I exit on blank cell? | Excel Programming | |||
Macro on exit cell | Excel Discussion (Misc queries) | |||
Run Macro on cell exit | Excel Programming | |||
If a called sub exit, how to the caller exit right away? | Excel Programming |