Did you read that other reply that used a worksheet_change event to change the
input range?

PCH wrote:

Hi Gang!

The width is actually the shortest base measurement of our scaffolding
product.
Depeding upon the width, determines the maximum height of the scaffold. A
scaffold that is to high for the width runs the risk of toppeling over.

I have several combo boxes that lets the user choose, the width, length and
height of the scaffold.

Therefore if the user selects a base width of 0.7m (2'4"?) there is a set
range of selectable heights. choosing a different width value again results
in an other set of height values etc.

At present I have a data validation set up where the range attached to it
has all the various height options. Using an if satement I can show only the
various heights available for the chosen width (=if(Width=0.7,MyValue,"").

It's cluncky but it works. The real problem is that some users do not know
to click into the cell to bring up the pull down values as the pull down icon
is not shown untill you actually click the cell.

Hope this explains in more detail.

Thanks

Wayne

"Dave Peterson" wrote:

What I'm thinking or what the original poster is thinking?????

I'm thinking that width is a name of a cell and the original poster can't change
the input range this way.

I'm thinking that depending on how that width cell changes, an event macro may
be used to change that input range.

AKphidelt wrote:

haha, most likely I'm wrong... I'm still just a beginner. My thought process
was that I knew Range1 and Range2 were probably named ranges, but what is
Width=.7 referring to is my question?

I would think it would have to be more like IF the width of what = .7. I'm
not that familiar with combobox's being able to change ranges though. I
usually use the cell link and just offset based off that. Let me know what
you're thinking and if Im wrong on any of this.

"Dave Peterson" wrote:

They looked like range names to me. But I've been wrong before.

AKphidelt wrote:

I don't see the logic behind that. What is the selection that determines if
the width is .7 metres? Because you're formula isn't directed at anything.
It's saying

= IF(the width of NOTHING = .7, Range1, Range2)

It has to be referenced to something.

"PCH" wrote:

Basic description....

if the width is 0.7 metres then select a height from the set of possible
values in range1, else if the width isn't 0.7 metres then choose the height
from the set of possible values from range2


"AKphidelt" wrote:

What are you really trying to achieve? If width of what = .7?

If width of the Combobox Selection? Cause I don't think it works like that.
Let me know what exactly you are looking to do with this.

"PCH" wrote:

I have a combobox on a work sheet.
I want to set the input range depending upon an if statement...

Input range =if(Width=0.7,Range1,Range2)

typing this statement into the input range does not work.

How can I achieve this?

regards

Wayne

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson