Lookup Range of Cells

Hi Mark

Thanks for getting in touch. Depending on your goal, there are a number of ways you could attempt this.

* You could record a VLOOKUP function in a macro
* You could record a Find action in a macro

The key really is to get the text box's value (e.g. textbox1.value) and use it within the code.

If you'd like to provide a little more detail on how it would work, I can suggest some other techniques that might help.

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