match data and then dispay result in a form

1. Sheet 1 contains a column of unique service call invoice numbers starting in R1C1.

2. Sheet 2 contains matching service call invoice numbers also in R1C1. R1C2 contains contains 255 characters of text with cariage returns inside the string of text.

3. I want to write a marco so that when I click on an invoice # in sheet 1, it will find the matching invoice # on sheet 2.

4. The macro should then display a form in sheet 1 that contains the string of text found in step 3. The carraige retunrs should cause the text to wrap inside the displayed form.

I would appreciate any advise. Thank you!!!!

Hi,
Where do you want to fetch the data on the form (In some list or text boxes) as well how many fields are there in your text string with de-limiters?
Regards,
Gajendra Gupta

The text string is in one field. The form can be a text box or list box - I'm not sure which is best. I want the data to appear in my window that same as a cell comment window pops up when you cursor over it.

Thanks for any help.

See the attached file... it may do what you asked.

I hope it can help you.

Regards,
Antonio