Re: Can the captions for Option Buttons be drawn from other cells ?

It might be able to be done, but you'd have to expand your details.

But excel has a nice built in way of choosing from a list.

You can use Data|Validation to choose from a list.
http://www.contextures.com/xlDataVal01.html

And if that list grows and contracts, you can use a dynamic range name.
http://www.contextures.com/xlNames01.html#Dynamic

Both of these are from Debra Dalgleish's site.

hedonist68 wrote:
>
> I'm trying to set up a workbook that allows users to select the names of
> staff using option buttons. There is a seperate *** for each day of the
> week with the same option buttons on each page. Is it possible to have a
> setup page where the names of the staff get inpput by the user, and then have
> the caption for each of the buttons linked to the appropriate cell on the
> setup page?

--

Dave Peterson
.