How to Populate One ListBox Based On Another ListBox

Guest

Hello everybody!

I have created a UserForm with 2 listboxes (comboboxes). The data for
those combo's is from an Access Database ( a table with 2 coloms).

I work with WORD/Access XP.

colomn 1: countries
colomn 2: cities

for example:
USA NewYork
France Paris
USA Washington

I need a macro that will enable me to choose a value in combobox 1
(for example: USA) and in combobox 2 I will get only the cities of
USA
(for example: New-York, Washington... end so on).

I will be very grateful for your HELP!!

Iris

Google · Sponsor

macropod · Guest

Hi Iris,

There's an example you can work from here:
http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=585,980

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

<irisbutnaru1@gmail.com> wrote in message news:1eaeb7f6-0684-4a2d-99e6-4b3825768951@e23g2000prf.googlegroups.com...