Hi all,

I have a label on a form (lblLocation) and I would like to look up the value in a text box on the same form (txtBus) which is in another worksheet "Location" (column B). and put the details of column C into the lblLocation's caption.

Any assistance would be appreciated

Regards

David