show comboxes

stone

Board Regular
Joined
Apr 25, 2002
Messages
138
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
 

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.
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.
 
Upvote 0
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 :)
 
Upvote 0
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.
 
Upvote 0
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
 
Upvote 0
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 (!)

:)
 
Upvote 0

Forum statistics

Threads
1,213,550
Messages
6,114,265
Members
448,558
Latest member
aivin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top