hello my Masters
i want to help you to get data and List for ComboBox 2 ,when i choose any Country from ComboBox1 ComboBox1 ALL Country ComboBox 2all cites for country list shown in ComboBox1
thanks alot
thanks alot ...This is exactly required
but we haven't any way to answer without Name Manager ,becaouse my main file Contains more than 100 countries, this Way will be very stressful
if you can possibe to be by this way ,which i make it in file by Drop DownList ,but i want as i sent before in Userform .This is because I couldn't apply the same idea in the Userform
as you see i used this formula to make List for Cities whwn i choose any country in Data Validation