Should I use Index/Match?

[mykulpasskwa]

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]

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.