Dave

It needs to be a combo box just by the fact that a conbo box has a pull down
icon and the data validation does not untill you click in it.

I know it's no too much of an ask to have people select the cell then the
value, but you'd be supprised on the number of phone calls....

"Dave Peterson" wrote:

Do you have to use a combobox?

How about a cell with Data|Validation?

Then you could use List with a source:
=INDIRECT(IF(width=0.7,"range1","range2"))
(notice that the range1 and range2 names are surrounded by quotation marks.)



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