Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Sep 2006
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Drop down /combo box help (Latest?)

    I want to use a combo box / drop down box with several values shown but I want the formula used to be different than what is shown in the box.
    For instance if 4" is the selcetion I want .085 to be used in a formula.

    Any help or example is appreciated.

    Thanks!

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Drop down /combo box help (Latest?)

    How are these examples?

    Data validation to get the value selected then pull the value for the calc with a VLOOKUP

    FORMS toolbar combobox to get the index number, then use the INDEX to get the 2nd value

    Control Toolbox can do it directly, if you set the "ListFillRange" to both columns and have the "ColumnCount" and "BoundColumn" both set to 2.

    Steve

Posting Permissions

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