I have the following file, which is attatched.

There are 2 boxes with radio buttons in it.
I would like to know what code to assign to my "Get Model" buttons s
that after I chose a selection from each of the 2 boxes and then clic
the button it goes to a certain view. I want to know if there's an
other way of doing this other than by "IF statements".

As you can see there are 4 tables under the 2 boxes.

If R3001 is selected in the first box and CW in the second I want it t
show just the first table(The one with "Incentive..."). If R3001 and N
are selected I want just the 2nd table to show. If R3001 and CA ar
selected I want the last 2 tables to show.

If R3000 and CW are selected I want the first and last table to show
If R3000 and NY are selected I want the middle 2 boxes to show. I
R3000 and CA are chosen I want all but the 1st to show.

I just need to get the feel of how the code works then I can do th
rest of the combinations because that's all it is just showin
different tables depending on what radio buttons are selected.

I just don't want to use if statements. I just want to use an easie
way.

Thanks, I appreciate your help

Attachment filename: interface.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=61152
--
Message posted from http://www.ExcelForum.com