combo boxes
combo boxes
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: combo boxes

  1. #1
    Guest

    Default

     
    I need to know something, I've created the combo box and linked it to the range of data.
    i have used "help" and discovered the index formula, but, i need to know how to make the selection that is clicked appear in another cell.

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    81,778
    Post Thanks / Like
    Mentioned
    12 Post(s)
    Tagged
    1 Thread(s)

    Default

    On 2002-03-13 14:51, Anonymous wrote:
    I need to know something, I've created the combo box and linked it to the range of data.
    i have used "help" and discovered the index formula, but, i need to know how to make the selection that is clicked appear in another cell.
    If you used Forms from Toolbars to create the ComboBox, you can use:

    =INDEX(SourceList,CellLink)

    where SourceList is what you used as Input Range and CellLink is the cell you anchored the ComboBox.

    [ This Message was edited by: Aladin Akyurek on 2002-03-13 15:07 ]

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Posts
    64
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    right no probs- you create the combo box based on the range of information you want to be picking from and give it a cell link - then in the cell where you want the information you pick to appear you enter an Index Function specifiying the range of cells that act as the basis for the combo box rang of cells as your array, and you set the cell you made as the cell link be the row source or cell -in the formula by selecting it - then if you pick the first name off the list using the drop-down box the no 1 appears in the cell link and then the index formlua looks down the list of information and finds the first cell entry.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com