Haven't we all beat our heads.

Are you using dropdown boxes on the sheet, or in a user created form?

I like creating vba forms with OK & Cancel buttons and list boxes and drop
down combos, you know.

Let me know if this would help.

"brucemc" wrote:


I'm sorry. The answer has got to be out here somewhere, but I feel like
I am beating my head against the floor.

A one sheet workbook.

Four named vertical ranges of 50 items each (Lets pretend each of the
four range names is a plant types).

50 named horizontal ranges of 4 items each (each range name is a 2
letter state abbreviations).

For simplicity, let's say that the resultant table is of the words
"No", "Poor","Good" "Great".

The user selects a state and a "plant" from two validation set drop
down lists. The workbook change event is triggered, and there goes the
code to determine the word or value in the cell that is at the
intersection of the two, let's say again for simplicity "MI" and
"Banana Tree", which would probably result in a "NO".

I can write the names of the ranges separated by a space after an = in
a cell and easily get the result, but I sure can't figure out how to
transfer the result of two drop-down boxes into same formula (at least
not so it works), and all the more worse to do so via VBA. I would LOVE
to be able to do so both ways, but just one would save me. Please help
before my head explodes.


--
brucemc
------------------------------------------------------------------------
brucemc's Profile: http://www.excelforum.com/member.php...o&userid=32871
View this thread: http://www.excelforum.com/showthread...hreadid=528753