user input via combo box in VBA

[Doug F.]

I want to click a button and have VBA solicit user input from a combo box (or
?) populated from a lookup table of cities. This input, i.e. City is then
used as a criteria in a SQL data extraction. Thanks.