Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: no it's no good i'm too under educated (combo box)

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    182
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Right i'm almost getting it.
    I've made the combobox.
    I've set it's range.
    In the cell link i've typed D13.
    now D13 displays the number corresponding to the list.
    what do i have to do to make this number become the text.

    Thanks to Audiojoe
    and Dave Hawley

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Where the wild roses grow
    Posts
    285
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Do you wanna send me your email address and I'll send you a combobox I've been doing

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

    Default

    do vlookup in another field and u will get the text u want!


  4. #4
    Board Regular
    Join Date
    Mar 2002
    Posts
    182
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-19 08:32, Audiojoe wrote:
    Do you wanna send me your email address and I'll send you a combobox I've been doing
    I DON'T KNOW IF I SENT A REPLY CORRECTLY BEFORE SO I THOUGHT I'D TRY THIS WAY TOO

    I'd really appreciate any help.
    jamiegibson2002@hotmail.com

    thanks

  5. #5
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Jammie

    Let's say your Combobox "Input Range" is A1:A20. Your Combobox "Cell Link" is B1. In any cell place:

    =INDEX(A1:A20,B1)


Some videos you may like

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
  •