#1   Report Post  
Navy Chief
 
Posts: n/a
Default Check / Uncheck Box

I found where I can insert a Check Box into a spreadsheet by right clicking
on a tool bar and clicking on control toolbox. But, I was unable to check or
uncheck the box.

When I click it, it will take me to a visual basic set up sheet and that is
where I get lost.

How to I lock in the check box in the spread sheet so I can use the check box.
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

There's a "design mode" on that same control toolbox toolbar. Click on that
icon to get out of design mode.

You could go into design mode, rightclick on the checkbox and choose a nice
linked cell--then you could use that in formulas in your worksheet. (Well, if
you need that kind of functionality.)

Navy Chief wrote:

I found where I can insert a Check Box into a spreadsheet by right clicking
on a tool bar and clicking on control toolbox. But, I was unable to check or
uncheck the box.

When I click it, it will take me to a visual basic set up sheet and that is
where I get lost.

How to I lock in the check box in the spread sheet so I can use the check box.


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Allowing only 1 check box to be ticked Nadia Excel Discussion (Misc queries) 12 November 28th 09 10:55 PM
Excell Check Digit Formula tnelson Excel Worksheet Functions 1 August 28th 05 11:30 PM
How do I use a check box to accept a calculation Joejoethecrackman Excel Discussion (Misc queries) 5 March 22nd 05 08:47 PM
Auto spell check as in word NC Excel Discussion (Misc queries) 2 January 27th 05 05:43 PM
Creating a check box that does not require security clearance. Maverick2U Excel Worksheet Functions 6 December 14th 04 02:46 AM


All times are GMT +1. The time now is 05:38 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"