| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Event (How post Date/Time to Changed Cells Rows but different Column)
Private Sub Worksheet_Change(ByVal Target As Excel.Range) MsgBox "Range " & Target.Address & " was changed." End Sub Using the above Sub: Facts: Range("A1:A5") values have been changed Goal: Need VBA to change Range("H1:H5") with Now() Challenge: What if more than one cell is changed? In short, if Target.Address = Range("A1:A5, A8") What VBA code would change Target.Address Rows 1,2,3,4,5,8 but same rows in Column "H"? TIA EagleOne |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change color of rows every time value in first column changes | Excel Worksheet Functions | |||
| Workbook change event when tab color changed? | Excel Programming | |||
| Change colour of cells when content is altered/changed BUT NOT TO INSERTED OR DELETED ROWS | Excel Discussion (Misc queries) | |||
| I had template that when you changed date of the event, it automa. | Excel Worksheet Functions | |||
| Code - if T changed, change date in W to date it is changed | Excel Programming | |||
Threaded Mode
