I have a field like Name of Company, name of Party, add1,
add2, add3, City, Pin, Off.Tel1, Off.Tel2, Fax, Res.Tel1,
Mobile, E-mail.

Is there any way can I type name of party it should
display all information of that party. & It is possible
that if I press say Example "A" it should display a list
of all party starting with "A" and I can select the party
and should display in Massage windows party name, Company
name, address telephone no., with ok button.
****al
..

There is no built in support for this. You can certainly code a userform to
do what you describe.



--
Regards,
Tom Ogilvy

"shah" wrote in message
...
I have a field like Name of Company, name of Party, add1,
add2, add3, City, Pin, Off.Tel1, Off.Tel2, Fax, Res.Tel1,
Mobile, E-mail.

Is there any way can I type name of party it should
display all information of that party. & It is possible
that if I press say Example "A" it should display a list
of all party starting with "A" and I can select the party
and should display in Massage windows party name, Company
name, address telephone no., with ok button.
****al
.

Have you looked at Data|Filter|autofilter?

You can filter on the Name and show just those rows that match. If you use the
dropdown arrow, you can select custom and then begins with, too.

Another option might be to drop a combobox from the controltoolbox toolbar on
the worksheet and use a few vlookup()'s in adjacent cells.

There's a matchentry property for the combobox that you might like.

(I'd use the Data|filter|autofilter.)

shah wrote:

I have a field like Name of Company, name of Party, add1,
add2, add3, City, Pin, Off.Tel1, Off.Tel2, Fax, Res.Tel1,
Mobile, E-mail.

Is there any way can I type name of party it should
display all information of that party. & It is possible
that if I press say Example "A" it should display a list
of all party starting with "A" and I can select the party
and should display in Massage windows party name, Company
name, address telephone no., with ok button.
****al
.

--

Dave Peterson