show comboxes

[stone]

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 ]

[gareth]

Can you explain in more detail please

[stone]

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.

[gareth]

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

[gareth]

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.

[Chris Davison]

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

[Chris Davison]

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 (!)