Results 1 to 4 of 4

Thread: List (2002)

  1. #1
    3 Star Lounger
    Join Date
    Mar 2004
    Location
    North Carolina, USA
    Posts
    268
    Thanks
    0
    Thanked 0 Times in 0 Posts

    List (2002)

    Hi, I have inherited a spreadsheet that contains a drop down list that is used in calculations. I would like to edit the source of the dropdown list to remove some items; however, I don't know where the source of the data that appears in the drop down list.

    How do I find this?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: List (2002)

    Is it a dropdown list in a cell? If so, select the cell and look at Data | Validation...
    Is it a dropdown list from the Forms toolbar? If so, right-click it and select Format | Control from the popup menu.
    Is it a combo box from the Control Toolbox? If so, activate design mode (first button on the Control Toolbox), select the combo box, then click the Properties button on the Control Toolbox. Look at the ListFillRange property.

  3. #3
    3 Star Lounger
    Join Date
    Mar 2004
    Location
    North Carolina, USA
    Posts
    268
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: List (2002)

    Hans, where do I find this? first button on the Control Toolbox

    Is it a combo box from the Control Toolbox? If so, activate design mode (first button on the Control Toolbox), select the combo box, then click the Properties button on the Control Toolbox. Look at the ListFillRange property

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: List (2002)

    The Control Toolbox is a toolbar. You can display it by selecting View | Toolbars | Control Toolbox, or by right-clicking any of the visible toolbars and selecting Control Toolbox from the popup menu.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •