In Sheet1 A1: AP1 have names of regions. Under the name of each region (ie in A2: An) are localities in that region. Meeting is a userform that will display combobox1 regions, a combobox2 they will be displayed depending on the selected region localities in combobox1 and a textbox that will be displayed postal codes of the localities.
Postal codes are in Sheet2. In odd-numbered columns starting with A2, C2 etc are names of localities and in even-numbered columns are postal codes of the locality.
May be empty cells in column postal codes
Can anyone guide me or help me with VBA code.
Thanks in advance to all who help me.