I'm trying to create an interface. I have 2 boxes.

Box #1 has 4 Radio buttons in it A,B,C and D. Box #2 has 3 Radi
buttons in it 1,2 and 3.

In each box under those radio buttons there is a button that says ge
info. I need a macro for that button that does the following withou
using "IF" statements in it.

I need it to just call a view on a different page, let's say the pag
is called UNO, that matches the combination of the radio buttons. So i
in the first boc A was selected and in the second box 1 was selecte
once you click on the get info button it would send you to view A1
Each combination has their own view.

I wanted to know if there is a simpler way of coding this without usin
if statements for each combination.

Thanks I appreciate your help

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

Have two variables - one for the "letter" and another for
the "number"

Each time an option is clicked, the relevent variable
altered and the view called.


Patrick Molloy
Microsoft Excel MVP


-----Original Message-----
I'm trying to create an interface. I have 2 boxes.

Box #1 has 4 Radio buttons in it A,B,C and D. Box #2 has
3 Radio
buttons in it 1,2 and 3.

In each box under those radio buttons there is a button
that says get
info. I need a macro for that button that does the
following without
using "IF" statements in it.

I need it to just call a view on a different page, let's
say the page
is called UNO, that matches the combination of the radio
buttons. So if
in the first boc A was selected and in the second box 1
was selected
once you click on the get info button it would send you
to view A1.
Each combination has their own view.

I wanted to know if there is a simpler way of coding
this without using
if statements for each combination.

Thanks I appreciate your help.


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

.