Should I use Index/Match?

mykulpasskwa

New Member
Joined
Mar 20, 2018
Messages
36
I have a dashboard where col B is academic terms and col D is their total fees. I have a hidden sheet with the breakdown of their fees that I want to load on that multipage.

When a user double clicks a term in column B a multipage in a userform pops up.

So if Semester 1 is double clicked the user form opens and I want VBA to look up the individual fees on the hidden page and populate the textboxes in the userform with those values. If it were Semester 2 it would look up Semester 2's values.

The way I'm looking at it, vba would have to look up the active cell which was double-clicked. Is this something that Index/Match is used for or should I be looking at something else?
 

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
9,566
Office Version
2007
Platform
Windows
You could upload a copy of your file with userfor to a free site such www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. If the workbook contains confidential information, you could replace it with generic data.
 

Forum statistics

Threads
1,084,850
Messages
5,380,276
Members
401,660
Latest member
Zakariyya Ibrahim

Some videos you may like

This Week's Hot Topics

Top