Combo box

Discussion in 'Excel' started by msnarayanan, May 14, 2017.

  1. msnarayanan


    Aug 19, 2016
    Likes Received:
    Dear all
    I have created list and inserted combobox from actvex in b6. Right clicking at the box, I selected properties. In the relevant place I entered the range where values are stored (o1.o42) and also entered the drop down lines as 42. Then I clicked design menu to come out.
    Now in b6 , combo box arrow appears and clicking on it I get the list to select. Till this point, no problem. But when I tried to enter data in b7
    with a combo box, there is no combo box appearing. I want the combo box appears in all the rows down b6.
    I do not where I went wrong
    Now I am using data validation dropdown.
    Please help me as to how I can create a combo box.

    M S Narayanan
    msnarayanan, May 14, 2017
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads