Hi,

can any one help me please ?

What I'm trying do to use combo box on a form I have created which
will display data in column 'A' e.g. Zip codes

When the user has found the Zip code they require in Column A, and
pressed the OK button the associated data in columns B, C & D will be
displayed in the Text box on the form

e.g. the user uses the combo box is used to select data in A12

Then press the OK Button

The data in B12, C12, D12 is displayed in the text box


Any assistance would be appreciated


Many thanks


Rob

NB Excel version 2000