Drop Down Menu

Hi Simon

Thanks for getting in touch. You can take a couple of approaches with it. You could use a VLOOKUP working with the existing drop down that retrieves the actual value you are after, perhaps in a separate table.

Alternatively you could use a Form in Visual Basic with a combo box control. You can then manipulate the result using something like Combobox1.Value.

Are any of these what you are looking for?

Kind regards

Gary Fenn
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector