Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
excel 2007 beta text box printing | Excel Discussion (Misc queries) | |||
Excel 2007 Worksheet | Excel Discussion (Misc queries) | |||
Excel 2007 - Custom menus is missing! | Excel Discussion (Misc queries) | |||
excel check boxes moving when excel selected cells pasted in word | Excel Discussion (Misc queries) | |||
Check boxes - when one box is checked, I want a 2nd box to auto ch | Excel Discussion (Misc queries) |