Reply to thread

As far as if Excel is the best tool for it, you haven't given enough detail on what you're trying to achieve.

What you're describing there is pretty simple though. Easiest way in my mind would be to put Data Validation on the first two cells and set it to a list of allowed values that you set elsewhere on the sheet (or another sheet). In the third cell, you apply a formula to concatenate the values from the first two cells, and then do a VLookup to another sheet where you're storing Key/Value pairs.

That way you don't have to muck around with VBA or any ActiveX stuff.