Link to home
Create AccountLog in
Avatar of Bright01
Bright01Flag for United States of America

asked on

Selecting a Validation Range and outputing Selection

EE Professionals,

I have a set of 15 questions that can be answered 3 different ways -- using an "Alpha" selction, a 1-5 selction (called "Sum") or a 1-10 selection (called "Detail").  The selction choices should be made by pushing a button that shows the Selection Choice (Alpha, Sum, Detail) and then reflects a validation list that will be in the drop down box in each cell next to the 15 questions.  Upon selection, it then posts to column K as it is converted by a formula in Cells  that is already in place in column K.

What I need is someone to show me how to create the button and apply the right validation selection based on the choice in the correct cell (in column C).

That's it!  Thank you in advance.

B.
Selecting-a-validation-range-and.xlsm
Avatar of Flyster
Flyster
Flag of United States of America image

I'm not sure if this is what you are looking for. I used a formula in data validation to select the drop down values.

Flyster
Selecting-a-validation-range-and.xlsm
Avatar of Bright01

ASKER

Flyster,

Very close!  But instead of choosing the number and then having the button reflect the appropriate selection, I'm looking for the reverse.  When you click the button, the text inside the button changes to the selection and the appropriate list box is then set.

You almost have it here.  I played with it for an hour and couldn't get it to work right.  Perhaps it's a simple fix.

Make sense?

B.
ASKER CERTIFIED SOLUTION
Avatar of Flyster
Flyster
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Flyster,

Excellent!  That's exactly what I had in mind.  Great work....... "definitely met my expectations!"

Thank you,

B.