Hi Venkat1926, the code that you have provided was fine. my purpose was served. I have another issue in the same program. I found this when I used it real time.
When I click on the down arrow symbol of the combo box active x control , I am getting a list (popup list window) with the names in my selected range to the right side of the combo box. that's fine. I am able to see only names with "A" in that window .I am unable to see the other names. I mean to say even if I press "k" in the combobox ,still the list is showing the starting entries/names of my range .Now my problem is I am not getting vertical scroll bar in that displayed list window. Is it possible to have a vertical scroll bar in that displayed window? so that when I press "H" in the combo box and press the down arrow symbol on the control box, I must be able to see the names starting with "H" in the displayed window also. Can you pls sort out this issue for me? thanks and regards Mr.Suryam