Apologies again for breaching the terms of both websites. Just to clarify though, when I said nobody seems to have a solution to my issue - I had asked people I know and on another Excel forum. It was at that point I created my account on this site and on Ozgrid but I of course accept the temporary ban I received.

Snb,

Thank you for your message and apologies for the delay in replying, I have been unwell for the past few weeks.

As you've probably gathered, I am a beginner with VBA.

The active x combo box is populated by lists of information stored in Sheet 2 of my workbook. I can provide a sample spreadsheet and I would be grateful if you could take a look and assist. If there is much work involved, I am happy to financially compensate you for your time.

I have asked this question and attached this spreadsheet on Ozgrid, I am yet to find a solution so I hope you will allow me to post here.