Conditional Formatting and Buttons

[lypto]

Hello,

I'm working on a project and I'm stumped at a particular point. I hav
an initial page that contains several "option" buttons. What I a
trying to accomplish is that upon selecting 1 button from each of the
categories(11 possibilities in total) I would like to have them setup s
that it will access specific "names" that I have created.

Is conditional formatting the appropriate manner to do this?

Any comments or suggestions will be greatly appreciated.

Thank yo

 

[Guest]

hi,
i am not sure if i understand you correctily but i don't
think conditional formating will do what you want.
sound more like a goto thing via macro.
Application.goto "rangename"
with 11 catagories this might get complicated. you will
have to have code to turn off all the other option button
if the user select another option button.
something like
if optionbutton1 = true then
optionbutton 2 = false
optionbutton 3 = false
ect.
end if
this might mean a lot of subs..one for each button.
I have done this in access but never in excel
I would guess you would put all this code in the worksheet
change evert.
good luck.