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

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

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

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