Combo box linked to cell

    Hi,
    is it possible to link a combo box to the cell below the combobox so that if you move or copy the combo box to a new cell it will link to the cell it is above.


    Or as an alternative could it be linked to the cell to its imediate left?


    Any help would be appreciated.

    Re: Combo box linked to cell


    What kind of combo box? Control Toolbox, forms, or is it on a userform?


    If its a form combo box, just right click and set the cell...use "$" to hold the reference cell if you want to move it around and hold the same cell.


    Control toolbox, you need to open the properties menu and type in the reference cell in "Linked Cell" line.

    Re: Combo box linked to cell


    Well the one i'm looking at is a control combo box.


    I can set it to show the data in a fixed cell but when i copy it to another cell it still links to the same cell, i want it to link to another cell without having to go into it and change the reference!

    Re: Combo box linked to cell


    The combo box list will have say 5 categories in it and will run down say column E for 50 rows, maybe more, so there will be 50 combo boxes. There will be an item in row C in the 50 rows. The items in row C needs to be categorised into one of the 5 categories in the combo box list and this will appear into column D next to it. The idea is to complete 1 combo box and copy it to the other 50 rows without having to change each one.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login