|
|
|
|
|
|
Excel
|
Audit formulae as you select cells
|
|
Ease of Use
|
Easy
|
Version tested with
|
2003
|
Submitted by:
|
mdmackillop
|
Description:
|
When you select a cell, if it contains a formula, then the precedent cells will be highlighted using the Auditing Toolbar indicator.
|
Discussion:
|
This code allows you to quickly inspect that your formulae relate to the correct set of cells. It can be turned on or off using the worksheet button.
|
Code:
|
instructions for use
|
Option Explicit
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If CommandButton1.Caption = "On" Then
ActiveSheet.ClearArrows
Target.ShowPrecedents
Else
ActiveSheet.ClearArrows
End If
End Sub
Private Sub CommandButton1_Click()
With CommandButton1
If .Caption = "On" Then
.Caption = "Off"
Else
.Caption = "On"
End If
End With
End Sub
|
How to use:
|
- Paste the code into the worksheet module that you wish to make available for auditing.
|
Test the code:
|
- Toggle the button to On
- Select a data cell in column E, F or Row 16
|
Sample File:
|
Audit.zip 9.17KB
|
Approved by mdmackillop
|
This entry has been viewed 204 times.
|
|