Dynamic Cross-Cursor in Excel – VBA

Downloads for this Tutorial:

Excel WorkBook
Download Now

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.

Downloads for this Tutorial:

Excel WorkBook
Download Now

Want more Tutorials?

See All Resources Get the latest Project Finance Tutorials and Blog Posts...

Subscribe to our newsletter

You will go into the draw to WIN a FREE training course.

Instantly unsubscribe at any time. We value your privacy.

Project Finance Training around the globe.

We provide leading project finance professionals with in-house training and four public courses in Asia, Europe, US and the Middle East.

Upcoming Courses:

Training Courses

Go

We provide both in-house training & professional public courses in more than four countries.

FREE Tutorials

Go

We have 30+ downloadable tutorials, PDFs, Excel workbooks and other tips and tricks available now...

Case Study

Asciano Limited Asciano Limited

Testimonial

Barry Casson, Chief Financial Officer
Would Australian Solomons Gold work with Navigator again? Absolutely. 110%. Australian Solomons Gold