#1   Report Post  
Posted to microsoft.public.excel.misc
jinvictor
 
Posts: n/a
Default about droplist


4858

thanx!!!


+-------------------------------------------------------------------+
|Filename: sample.JPG |
|Download: http://www.excelforum.com/attachment.php?postid=4858 |
+-------------------------------------------------------------------+

--
jinvictor
------------------------------------------------------------------------
jinvictor's Profile: http://www.excelforum.com/member.php...o&userid=34099
View this thread: http://www.excelforum.com/showthread...hreadid=549403

  #2   Report Post  
Posted to microsoft.public.excel.misc
Zygan
 
Posts: n/a
Default about droplist


attached is a copy of the workbook which hopefully will help


+-------------------------------------------------------------------+
|Filename: Book1.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4860 |
+-------------------------------------------------------------------+

--
Zygan
------------------------------------------------------------------------
Zygan's Profile: http://www.excelforum.com/member.php...o&userid=34423
View this thread: http://www.excelforum.com/showthread...hreadid=549403

  #3   Report Post  
Posted to microsoft.public.excel.misc
jinvictor
 
Posts: n/a
Default about droplist


Zygan Wrote:
attached is a copy of the workbook which hopefully will help


its helpful, but i want is: a1 is droplist with cities data, b1 is
droplist with countries data, when you choose usa in b1, a1 is usa's
cities droplist so you can choose cities, when you choose australia in
b1, a1 shows australia's cities for you to choose, but when b1 is
blank, a1 is china's cities' droplist.

thanx


--
jinvictor
------------------------------------------------------------------------
jinvictor's Profile: http://www.excelforum.com/member.php...o&userid=34099
View this thread: http://www.excelforum.com/showthread...hreadid=549403

  #4   Report Post  
Posted to microsoft.public.excel.misc
Zygan
 
Posts: n/a
Default about droplist


try this one out

is this what your after?


+-------------------------------------------------------------------+
|Filename: Book1.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4861 |
+-------------------------------------------------------------------+

--
Zygan
------------------------------------------------------------------------
Zygan's Profile: http://www.excelforum.com/member.php...o&userid=34423
View this thread: http://www.excelforum.com/showthread...hreadid=549403

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
mulitiple droplist jinvictor Excel Discussion (Misc queries) 2 June 4th 06 10:34 AM
Extracting Text Brian Excel Worksheet Functions 8 March 7th 06 11:08 PM
Dependant Droplist showing distinct records andrew37_37 Excel Worksheet Functions 1 August 30th 05 07:36 AM
Urgent: How to bring data from another sheet into a droplist bnr32 Excel Discussion (Misc queries) 2 August 29th 05 10:00 AM
HOW TO USE HYPERLINK within a droplist? Bonny Excel Discussion (Misc queries) 1 August 26th 05 03:39 PM


All times are GMT +1. The time now is 03:49 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"