Re: Combo box - input Range

Tech-Archive recommends: Fix windows errors by optimizing your registry

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 ***.
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
.

Quantcast