Dynamic Cross-Cursor in Excel – VBA

This article outlines a neat trick in how to code a very professional looking dynamic cursor in any table in excel using a short VBA macro and conditional formatting.

The following presentation trick can be achieved in just minutes using a combination of Named Ranges, VBA (Worksheet_SelectionChange) and Conditional Formatting (three conditions).

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

[RowSelection] = Target.Row

[ColumnSelection] = Target.Column

End Sub

If you liked this trick, then you should read more about our VBA for Financiers course where this topic is discussed in detail.

Share this post

 

You must be logged in to view the Tutorial