Part 1 – Mark Cell as Dirty

Part 2 – Dirty Cells Update

Mark cell as dirty

Part 1 – simply highlights the cells

ADD THIS: if InAGet then exit Worksheet_Change

• This should be at the Top.
• See Runtime sheet. It has a Worksheet Named Range ‘InAGet’
• Sub HighlightEdits(strFlag As String) ‘rename this IsInAGet

  If strFlag = “On” Then
  Range(“InAGet”).Value = “No”
  Else
  Range(“InAGet”).Value = “Yes”
  End If

  End Sub

 

Check if Cell is in Range

Check if the Column is editable

Check if the entered Data is valid

Highlight the Cell

Turn on the Save button

Part 2 – trawls through the sheet and does the following with each highlighted cell.

2.1 – makes a list of SQL UPDATE statements

 

 

2.2 – executes the list