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

You want to evaluate multiple criteria and perform conditional actions
without checking the criteria to see what condition is matched?

Try explaining what you want to do without using IF. (or substituting a
word for IF). If that appears feasible, then perhaps you can can code it
that way.

--
Regards,
Tom Ogilvy


"grin2000 " wrote in message
...
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 so
that after I chose a selection from each of the 2 boxes and then click
the button it goes to a certain view. I want to know if there's any
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 to
show just the first table(The one with "Incentive..."). If R3001 and NY
are selected I want just the 2nd table to show. If R3001 and CA are
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. If
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 the
rest of the combinations because that's all it is just showing
different tables depending on what radio buttons are selected.

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

Thanks, I appreciate your help.

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

I want the code to work the same way as if using IF and END IF bu
without using IF and END IF

--
Message posted from http://www.ExcelForum.com

Use a CASE statement then.

--
Regards,
Tom Ogilvy

"grin2000 " wrote in message
...
I want the code to work the same way as if using IF and END IF but
without using IF and END IF.


---
Message posted from http://www.ExcelForum.com/