How to Populate One ListBox Based On Another ListBox

I

irisbutnaru1

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Populate One ListBox Based On Another ListBox 4
populate a combobox based on unique values in another workbook 16
How to sum up the value in column based on a 5 day week period? 1
Populate a userform from a worksheet 1
ADDING values from one listbox to another on same form 1
Moving to an entry in a listbox 9
transfer data from one listbox to another 2
Select Multiple value from Listbox in MS Access 5

Top