Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
sd sd is offline
external usenet poster
 
Posts: 1
Default Popup window (plz replay)

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
....



  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Popup window (plz replay)

This can be done with a userform. You woul have to write the code to do
it - there is no built in functionality for it.

One thing you might look at is in the Data Menu, choose Form . . .
doesn't do exactly what you want, but is close.

--
Regards,
Tom Ogilvy

"sd" 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
...





  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Popup window (plz replay)

You can do this with a userform - you would need to write the code.

Also look at data = Form . . .

--
Regards,
Tom Ogilvy

sd 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
...





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I get a popup window on a VLOOKUP lookup failure? Mark F[_2_] New Users to Excel 6 June 30th 11 12:41 AM
Popup window on open kraway Excel Discussion (Misc queries) 1 January 12th 07 03:19 PM
How do I create a popup window based on a cell value? bumper338 Excel Discussion (Misc queries) 2 November 28th 06 03:05 PM
popup message window Tom Ogilvy Excel Programming 0 August 26th 03 01:02 PM
Popup message window with name shah[_2_] Excel Programming 2 August 26th 03 02:40 AM


All times are GMT +1. The time now is 06:36 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"