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 and public training in Asia, Australia, US, Canada, the Middle East and South Africa.

Upcoming Courses:

Training Courses

Go

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

FREE Tutorials

Go

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

Testimonial

Mathew Leonard, General Manager Infrastructure
Navigator has a proven track record in delivering specialist services to the project finance sector. Engaging Navigator is very low risk because I’m giving the task to someone who I know with a high degree of certainty can do the job and give me what I want in return. The main benefits of Navigator are speed, low delivery risk and the quality of their product. They have certainly met my expectations. I didn’t want to use the large accounting or actuarial firms because the modelling is often left to inexperienced staff. Ma'aden Infrastructure