Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 13
Default Check Boxes in excel 2007

Oh, absolutely correct! I'm on Excel 2000.

Hope your comment solves the problem.

Thanks!

Hans


Jim Rech schrieb:

I'm not sure Hans noticed you were asking about Excel 2007.

Check boxes, etc., are on the Developer tab of the Ribbon. The Developer
tab is not visible by default. To make it appear click the Office menu (the
circle in the top left of Excel) and then click Excel Options at the bottom
right of this menu. Select the third item on the "Popular" section.

Then on the Developer tab click Insert in the Controls group. I'd suggest
you select the Forms check box but the ActiveX version is there too.

--
Jim
"aleap" wrote in message
...
| Hans - thanks for the reply but I cannot locate the green triangle which
| respresents design, can you lead me to where that is located? Also I am
| runnning Excel 2007 (beta), not sure if you picked that up or not. I look
| forward to your reply and thanks for the effort so far.
|
| aleap
|
| "flummi" wrote:
|
|
| aleap schrieb:
|
| How does one insert a check box in 2007? I just need it to display a
check
| mark when selected. Nothing more complex than that. Any ideas?
|
| You can insert a checkbox from the controls toolbar.
|
| Click "design" (the grean triangle) then click the checkbox icon and
| drag a rectangle over the cell where you want the checkbox to appear.
| Then right click the checkbox and select "properties", Under "linked
| cell" you specify the cell that's going to hold the result of the
| checkbox and under "caption" you explain what the box is to specify.
|
| Regards
|
| Hans
|
|


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
excel 2007 beta text box printing Asterix Excel Discussion (Misc queries) 3 July 18th 06 05:32 PM
Excel 2007 Worksheet elusiverunner Excel Discussion (Misc queries) 2 July 12th 06 02:58 AM
Excel 2007 - Custom menus is missing! Søren Thade Petersen Excel Discussion (Misc queries) 3 July 11th 06 01:59 AM
excel check boxes moving when excel selected cells pasted in word Erik Excel Discussion (Misc queries) 0 July 7th 06 05:00 PM
Check boxes - when one box is checked, I want a 2nd box to auto ch Russell-stanely Excel Discussion (Misc queries) 2 July 1st 05 08:52 PM


All times are GMT +1. The time now is 04:11 PM.

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

About Us

"It's about Microsoft Excel"