Check Boxes & Data Validation

G

Guest

I have two check boxes (from forms toolbar), Two named ranges, and one cell
for a dropdown (Data Validation list). Is it possible to tie one of the
check boxes to each of the named ranges and have the selected check box
populate that named range on the data validation list.

Mike Rogers
 
B

Biff

Hi!

You'd be better off using option buttons. Using checkboxes allows for more
than one to be checked at a time. Only one option button can be selected at
a time.

I'll reply as though you are using option buttons.

OK, so you have 2 option buttons and 2 named ranges: Range1 and Range2.

Edit the text of the option buttons and insert the named ranges.

Option button 1 will be for Range1 and option button 2 will be for Range2.

Link the option buttons to a cell, say, A1.

For the data validation.....

Select List and enter this formula in the Source box:

=CHOOSE(A1,Range1,Range2)

When you select ob1 it will return 1 to cell A1. When you select ob2 it will
return 2 to cell A1.

If you do this you might get a message when you're setting the data
validation to the effect: The source currently evaluates to an error. Do you
want to continue?

Just answer Yes.

The reason you would get that message is because initially, neither button
would be selected meaning that there is no source.

Biff
 
G

Guest

Hey Biff

Got the idea and it makes sense. A couple of questions, do I use the option
buttons from control toool box or forms tool bar? I am assuming I will use
control tool b yox because it has a properties button that I can use to edit.
Which leads me to my next question. You said to edit the option button to
insert a named range, how do I do that? I look at the information
properties and it is pretty foreign to me. I can link the buttons to a cell
but need direction on editing the text to insert named ranges. Thanks for
the help Biff you have helped me many times before, so thanks again

Mike Rogers
 
G

Guest

Biff

Just kept "clicking" around and it was a "Duh" when I found edit text....
got it working!!!! Thanks again

Mike Rogers
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
Filesize: embedded data validation lists all stored independently? 2
Data Validation Error 1
Data Validation - dependant Lists 1
Data Validation List with blanks 1
Data Validation with dynamic ranges 2
2007 data validation not working 1
Data validation: concatenate two separate ranges in the List? 3

Top