Thanks Thanks:  0
Likes Likes:  0
Results 1 to 7 of 7

Thread: show comboxes

  1. #1
    Board Regular
    Join Date
    Apr 2002
    Location
    iceland
    Posts
    138
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi guys.

    I was wondering,....what I need to do is...
    if cell A8 is "NOT BLANK" then a combobox appears in cell B8, that combobox has B8 as the linked cell, but its input range is in another worksheet.

    ...if you have any idea how this is done, then for god sake push the "quote" button.

    Thanx. (K)


    [ This Message was edited by: stone on 2002-05-06 04:36 ]

  2. #2
    Board Regular
    Join Date
    Apr 2002
    Location
    Cape Town,South Africa
    Posts
    234
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Can you explain in more detail please

  3. #3
    Board Regular
    Join Date
    Apr 2002
    Location
    iceland
    Posts
    138
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    okey, this is what i am working with.

    cell B15, contains Room number
    cell C15, Name of the room
    cells D15-F15, lenght,with,height of the room
    you have to fill cells B15 to F15 out manually
    cells G15-I15, contain three linked comboboxes(which allow you to select a type of radiator for the room), and cell J15 contains a certain outcom.

    ...so if i have five rooms, then i have to fill out lines 15 to 19, and Cell J20 contains the sum of values in J-column.

    so when i start to fill out line 16, then the comboboxes should "appear" in cells G16 to I16.

    ....what I am trying to say is that, the number of room can be different.

    ...i hope this helps you to understand what i am trying to do.


  4. #4
    Board Regular
    Join Date
    Apr 2002
    Location
    Cape Town,South Africa
    Posts
    234
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    okey, this is what i am working with.

    cell B15, contains Room number
    cell C15, Name of the room
    cells D15-F15, lenght,with,height of the room
    you have to fill cells B15 to F15 out manually
    cells G15-I15, contain three linked comboboxes(which allow you to select a type of radiator for the room), and cell J15 contains a certain outcom.

    ...so if i have five rooms, then i have to fill out lines 15 to 19, and Cell J20 contains the sum of values in J-column.

    so when i start to fill out line 16, then the comboboxes should "appear" in cells G16 to I16.

    ....what I am trying to say is that, the number of room can be different.

    ...i hope this helps you to understand what i am trying to do.



    Can you email the sheet to me (if it's not too private garethl@ij.co.za
    I will see what I can do to that sheet of problems

  5. #5
    Board Regular
    Join Date
    Apr 2002
    Location
    Cape Town,South Africa
    Posts
    234
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have alot of examples on hand you see,so I can help you better if I can see personally what the sheet looks like my friend.

  6. #6
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Stone,

    this solution is a bit fiddly, so hopefully someone can tidy it up a bit :

    highlight your list of radiators
    insert
    name
    define
    name=radiator
    add
    okay

    (this creates a named range called "radiator")

    somewhere close to this highlighted list of radiators (maybe directly above it, but for this example we'll use cell XX99) put the following formula :

    =IF(ISBLANK(B15)=TRUE,"","radiator")

    this tells the cell to display the word "radiator" if B15 is blank - remembering that B15 is your room number

    in cell G15 :

    data
    validation
    settings
    allow: list
    scource: =INDIRECT($XX$99)
    incell dropdown: yes

    (remember to change my $XX$99 to wherever you put your earlier formula, but be sure to anchor it with the $$)

    now drag the cell G15 to H15 and I16 and as far down as needed and the data validation should hold for all of them




    :: Pharma Z - Family drugstore ::

  7. #7
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-05-06 04:36, stone wrote:
    but its input range is in another worksheet.
    [ This Message was edited by: stone on 2002-05-06 04:36 ]
    shouldn't be a problem...as long as you mean a worksheet and not another workbook (!)


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
  •