Combo box

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

  1. msnarayanan

    msnarayanan

    Joined:
    Aug 19, 2016
    Messages:
    29
    Likes Received:
    1
    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
    1. Advertisements

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
  1. iggydarsa
    Replies:
    0
    Views:
    332
    iggydarsa
    Apr 27, 2015
Loading...