"Radio Bottons"

[grin2000]

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

 

[Patrick Molloy]

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