Input box on click of cell that contains dynamic text.

Hi,

I am trying to build a filterbale calendar which counts the amount of high, medium, low complexity change and gives names of these on click.

I need to get this to filter to region and site and then i need it so that when you select a cell with the number of those bits of change an input box appears with the names of the change.

I have set up a data sheet which has all of this info in it.

I have no idea where to start with VBA for this?

At the moment i have the calendar filtering on a hidden pivot table.

I would ideally also like for the change names to be bulleted or numbered in the input box too.

If anyone could help it would be much appreciated. i have attached the file.

Thanks,

Nic