Hello
I'm using Excel 2003. I'm a VBA beginner..
I want to create a userform and I need support. Google sent me to you
I have 2 worksheets. One of them is for the "Database" and the other one is for "EnteredData".
On a userform I want to select or write in a combobox the german postal code and the other combobox should automatically show the city.
When I click the button "Enter", the selected zip code should be entered in column F and the city should be entered in coulumn G.
If there are several places on this postal code, just this cities should be displayed on the opened combobox.
If there are not one of the entered postal code, the newly registered postal code and newly registered place should be added on the sheet "database" and sorted by the postal code.
For your help I would be very grateful.
As Annex I add the userform (with code) with the addition of the 2 Sheets.
Download here: help.xls
Bookmarks