| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Have Cell To Left Show Fixed Time When Cell Changes
I've tried this
Private Sub Worksheet_Change(ByVal Target As Excel.Range) If Target.Cells.Column = 2 Then n = Target.Row If Excel.Range("A" & n).Text = "" And Target.Cells.Text < "" Then Excel.Range("A" & n).Value = Now End If End If End Sub suitably amended, and some others, but can't seem to get them to work. I want E7 to show time as soon as F7 is <"", E8 to show time as soon as F8 is <"", etc - for any worksheet in the workbook, not just on one worksheet. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| show row number in one fixed cell in reference to your cursor pos. | Excel Discussion (Misc queries) | |||
| Show a Cell at Top Left | Excel Discussion (Misc queries) | |||
| top/left cell borders don't show | Excel Programming | |||
| enter a time into a cell, have the cell show two times the entry | Excel Worksheet Functions | |||
| Show a time from one calculated cell as a decimal in another cell. | Excel Worksheet Functions | |||
Threaded Mode
