XL2000 and Radio Buttons

  • Thread starter Thread starter Dawn
  • Start date Start date
D

Dawn

I created a form for my sales staff in Excell 2000. I
included some questions on the form that may be answered
by clicking on radio buttons to make a choice. This works
GREAT in regular .xls format.

The problem occurrs when I save the file as a template
(.xlt format). When saved as a template, a user can click
on a radio button for one question, and as soon as another
radio button for a different question, in a different cell
is clicked, all other radio buttons get un-checked.

I've checked everything, and the objects aren't linked,
there is no vb code indicating a link, and as I said, the
problem doesn't exist in .xls format.

Any suggestions on a source of the problem, and possible
fixes would be greatly appreciated.

Dawn
 
Dawn,

Presumably, you've used radio buttons from the Control Toolbox, not vanilla
ones from the Forms Toolbar. I don't know if those from Forms can be
grouped anyway. In Properties you use a common GroupName to group them.
Using radio buttons from the Control Toolbox, I've just tried saving as a
template, and the grouping worked when a new workbook file was created using
that template. XL 2002.
 
If you put the Forms toolbar optionbuttons (aka radio buttons) inside a group
box, then you can group those, too.
 
Dave,

Ya know, I was sure I'd grouped them before, and looked all around before I
posted. That neuron just wouldn't fire. Thanks. Maybe I need a bourbon.
 
Thanks for the suggestion. Someone in the office
suggested I try this too. I did, but still have the same
problem. I'm getting flummoxed over this one. :{
 
Make sure you have the optionbuttons totally within the groupbox.

If that wasn't it, what problem are you experiencing?

(or were you saying that someone suggested the bourbon solution, too!)
 
Back
Top