×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Inserting Simple Check Boxes and Option Button in Forms

Inserting Simple Check Boxes and Option Button in Forms

Inserting Simple Check Boxes and Option Button in Forms

(OP)
I am in need of some simple and clear instructions on employing Check Boxes and Option Buttons in my Excel Forms and Specification Sheets.  These features are real time savers and "no-brainer" types of accurate user input.

However, I've not been able to depend on Microsoft for clear instruction on how to employ these items in my specification sheets.  I would appreciate any leads or recommendations on how or where to find this basic information.

Thanks

Art Montemayor
Spring, TX

RE: Inserting Simple Check Boxes and Option Button in Forms

Go to DATA>VALIDATION>ALLOW and select the options you wish. If you use LIST, than you will be asked for the cells with the list. The list can be text or numbers. When the user makes the selection, the exact value from the list is inserted into the validated cell.

The above dialog box also allows for naming the drop-down menu and a baloon pop-up that lets you explain the data entry.

Its a good idea to use validated data if the answer is going to be in an IF statment, eleminates typos and case erors for the user.

RE: Inserting Simple Check Boxes and Option Button in Forms

(OP)
GearmanPE:

Thanks for the information, but I'm already familiar with drop-down boxes and lists.  What I'm looking for information on is Check Boxes and Option Buttons.  

Art Montemayor
Spring, TX

RE: Inserting Simple Check Boxes and Option Button in Forms

Firstly the check boxes.

These are on the forms control bar (I'll asume you know this and have this displayed already).

Click on the check box item, and then draw a box using mouse in worksheet in approx. location by dragging mouse (the location of check box is movable)

Right click the check box and click on format control. In cell link box either type cell link or click far right coloured botton, and then click in cell to be linked, hit enter.

Click on check box, and notice value of true or false change relating to check box.

The option button is almost the same as the check box.
Differeing in that option buttons are grouped together (only one option button can be checked. You can group serveral option buttons together using the group box, which makes one set of option buttons seperate from the others.

With the valuse in linked cells, you can then make reference via IF statements and the like.

Give this a play and see what you come up with.

If you need more info just ask.

RE: Inserting Simple Check Boxes and Option Button in Forms

If you use the Control Toolbox toolbar instead of the Forms toolbar, there is no need for a group box.
The Forms toolbar is a sort of legacy from earlier versions of Excel, with which you can do some amazing things. However, starting Excel 5.0 (I think) the Control Toolbox was added, which gives access to the Office controls, giving you more flexibility and options, and a modernized look.
When you select a control, say an option button, you can click on the "Properties" button to display - guess what - its properties, such as color, size, position, status (checked/unchecked/mixed), etc.
One of the properties for an option button is GroupName. All option buttons with the same GroupName are connected, such that only one of them can be selected. Selecting a different option button in the same group will deselect the others.
Good luck experimenting...

Cheers,
Joerd

Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members! Already a Member? Login


Resources

Low-Volume Rapid Injection Molding With 3D Printed Molds
Learn methods and guidelines for using stereolithography (SLA) 3D printed molds in the injection molding process to lower costs and lead time. Discover how this hybrid manufacturing process enables on-demand mold fabrication to quickly produce small batches of thermoplastic parts. Download Now
Design for Additive Manufacturing (DfAM)
Examine how the principles of DfAM upend many of the long-standing rules around manufacturability - allowing engineers and designers to place a part’s function at the center of their design considerations. Download Now
Taking Control of Engineering Documents
This ebook covers tips for creating and managing workflows, security best practices and protection of intellectual property, Cloud vs. on-premise software solutions, CAD file management, compliance, and more. Download Now

Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close