Biff

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

Mike Rogers

"Biff" wrote:

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

"Mike R" wrote in message
...
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