[SOLVED] Indexing proper range in listbox depending on selection in previous listbox

I am trying to figure out how to populate proper range in ListBoxCity based on selection in ListBoxCountry. First I choose Country, it populates State/Province properly, and if I chose United States in the first box, City names are proper, but as it sits, if I chose Canada, it lists US cities.

Please Login or Register  to view this content.

If I could make the Private Sub ListBoxState give the range in my code above if United States is chosen, and this range if Canada was chosen:

Please Login or Register  to view this content.

I would be so greatful. I'm a little confused by the 'if then else', and my searching has found dozens of examples that don't work for me. thanks