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

I'm trying to set up a workbook that allows users to select the names of
staff using option buttons. There is a seperate sheet 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?

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 sheet 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

Thanks for the links...that would be another way way to do what I'm after.
What I'm looking at is a sheet that tracks missing product and assigns a
dollar value to what's missing. At the bottom of the page is a list of names
with a check box beside each name. As each name is checked, the total owed
get divided by the number of checked boxes. I was hoping that that the check
box could be linked to a setup page where the user enters the names of their
staff and the link puts the name into the caption setting of the box, but it
doesn't seem to want me to put a formula in that field.

"Dave Peterson" wrote:

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 sheet 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

You could use a linked cell for each of those checkboxes. That linked cell
could be on any sheet (or you could use a formula on any sheet that refers back
to that linked cell).

Then maybe a
=sumif(rng,true,rngtoadd)
would work for the checked boxes
or
=sumif(rng,false,rngtoadd)
for the unchecked items.




hedonist68 wrote:

Thanks for the links...that would be another way way to do what I'm after.
What I'm looking at is a sheet that tracks missing product and assigns a
dollar value to what's missing. At the bottom of the page is a list of names
with a check box beside each name. As each name is checked, the total owed
get divided by the number of checked boxes. I was hoping that that the check
box could be linked to a setup page where the user enters the names of their
staff and the link puts the name into the caption setting of the box, but it
doesn't seem to want me to put a formula in that field.

"Dave Peterson" wrote:

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 sheet 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


--

Dave Peterson