View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
kassie kassie is offline
external usenet poster
 
Posts: 515
Default Listbox value depending on other listbox value

You need to set up a list of towns for each country. Name the list of towns
after the country they relate to. The list of countries you could name
Countries. For each country you would then have a seperate list. Say you
have Argentina, Equador, Poland, Russia, South Africa. The source for
listbox1 would then be Countries.

In your second listbox, indicate the source as =INDIRECT(Listbox1). In this
way, it would read the list from the range name pertaining to that country.

--
HTH

Kassie

Replace xxx with hotmail


"noord453" wrote:

Hi,

I use in 1 form 2 listboxes, one to select a country, and one to select a
city. If the user selects a county, automaticly from the list a default city
shoudl be made visible in the second listbox. At this moment the default is
not set, possible because the value of the first listbox is not yet set in
the worksheet?

How to make this happen?

regards
Gerard