Link two ComboBoxes

		Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
Link two ComboBoxes

Excel VBA Discuss using VBA for Excel programming.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

May 22nd, 2006, 02:30 PM

stepdev

Authorized User

Join Date: Mar 2006

Posts: 21

Thanks: 0

Thanked 0 Times in 0 Posts

Link two ComboBoxes

I have a list of cities in column A1 and a list of zip codes in column B1. List 1 is tied to ComboBox 1, and list 2 to ComboBox2. How can I make sure that when I select, for example, the City Baltimore from Combobox1, I only get a list of all zip codes for Baltimore available to select from in ComboBox2?

I tried data validation which does not seem to work.

Help! please. This is a Biggie Big!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Filter using a Pop-up Form and Comboboxes	Odeh Naber	Access VBA	3	August 7th, 2008 07:39 AM
2 ComboBoxes in VB.NET	vas	General .NET	0	May 8th, 2008 08:51 AM
Corresponding values change in comboboxes	gaurav_jain2403	ASP.NET 1.0 and 1.1 Professional	4	May 19th, 2006 10:03 AM
Linked Comboboxes at the database level?	howardb1	Access VBA	7	April 27th, 2006 04:17 AM
Menu is drawn behind comboboxes	rmattila	Javascript How-To	3	December 14th, 2004 05:13 AM