maybe you should write it more clearly. I thought it might be realized by set datasource of combo. otherwise, it needs vba.