check box in Excel?
 

I created an expense form in Excel. I want the users of this form to have the
ability to place a check in a check box that best answers a question. I dont
need a macro to complete this task. Can anyone please assist me?

VIEW / TOOLBARS / CONTROL TOOLBOX
Click on the Check Box. Put it on the worksheet where you want it by
clicking on the CheckBox, going to where you want the box to be. Left-click
and hold while you draw a box the size you want. Then click on the 'Exit
Design Mode' button on the Control Toolbox (1st control on top left of
toolbox). Close the toolbox.
HTH,
Gary Brown



"Mike B." <Mike wrote in message
...
I created an expense form in Excel. I want the users of this form to have
the
ability to place a check in a check box that best answers a question. I
dont
need a macro to complete this task. Can anyone please assist me?

After following the steps recommended, I try clicking on the check box and
immediately go to Microsoft Visual Basic (design view i think). I have no
idea what to do here. PLEASE HELP!!!

"Gary Brown" wrote:

VIEW / TOOLBARS / CONTROL TOOLBOX
Click on the Check Box. Put it on the worksheet where you want it by
clicking on the CheckBox, going to where you want the box to be. Left-click
and hold while you draw a box the size you want. Then click on the 'Exit
Design Mode' button on the Control Toolbox (1st control on top left of
toolbox). Close the toolbox.
HTH,
Gary Brown



"Mike B." <Mike wrote in message
...
I created an expense form in Excel. I want the users of this form to have
the
ability to place a check in a check box that best answers a question. I
dont
need a macro to complete this task. Can anyone please assist me?