software

A want to insert a check box that can be toggled on and off by clicking on it.

Hi Joergiman,

View | Toolbars | Forms | Double click the checkbox | click the worksheet.
Click the toolbar checkbox | Close the toolbar---
Regards,
Normanquot;joergiemanquot; gt; wrote in message
...
gt;A want to insert a check box that can be toggled on and off by clicking on
gt;it.
How to insert a check box it in Excel 2007?

quot;Norman Jonesquot; wrote:

gt; Hi Joergiman,
gt;
gt; View | Toolbars | Forms | Double click the checkbox | click the worksheet.
gt; Click the toolbar checkbox | Close the toolbar
gt;
gt;
gt; ---
gt; Regards,
gt; Norman
gt;
gt;
gt; quot;joergiemanquot; gt; wrote in message
gt; ...
gt; gt;A want to insert a check box that can be toggled on and off by clicking on
gt; gt;it.
gt;
gt;
gt;

Joergiman,

On the Menu bar select Developer, then Insert and double click the Checkbox
in the Form Controls section. (Or single click and draw the box where you
want it on the spreadsheet.

Rob

quot;Narnimarquot; gt; wrote in message
...
gt; How to insert a check box it in Excel 2007?
gt;
gt; quot;Norman Jonesquot; wrote:
gt;
gt;gt; Hi Joergiman,
gt;gt;
gt;gt; View | Toolbars | Forms | Double click the checkbox | click the
gt;gt; worksheet.
gt;gt; Click the toolbar checkbox | Close the toolbar
gt;gt;
gt;gt;
gt;gt; ---
gt;gt; Regards,
gt;gt; Norman
gt;gt;
gt;gt;
gt;gt; quot;joergiemanquot; gt; wrote in message
gt;gt; ...
gt;gt; gt;A want to insert a check box that can be toggled on and off by clicking
gt;gt; gt;on
gt;gt; gt;it.
gt;gt;
gt;gt;
gt;gt;

I want tick/untick when I mouse click on this object same like in excel
2003. but this is not working. ow can I do it?

quot;RobNquot; wrote:

gt; Joergiman,
gt;
gt; On the Menu bar select Developer, then Insert and double click the Checkbox
gt; in the Form Controls section. (Or single click and draw the box where you
gt; want it on the spreadsheet.
gt;
gt; Rob
gt;
gt; quot;Narnimarquot; gt; wrote in message
gt; ...
gt; gt; How to insert a check box it in Excel 2007?
gt; gt;
gt; gt; quot;Norman Jonesquot; wrote:
gt; gt;
gt; gt;gt; Hi Joergiman,
gt; gt;gt;
gt; gt;gt; View | Toolbars | Forms | Double click the checkbox | click the
gt; gt;gt; worksheet.
gt; gt;gt; Click the toolbar checkbox | Close the toolbar
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; ---
gt; gt;gt; Regards,
gt; gt;gt; Norman
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; quot;joergiemanquot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt;A want to insert a check box that can be toggled on and off by clicking
gt; gt;gt; gt;on
gt; gt;gt; gt;it.
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;

Hope someone else can help....works fine on my Excel 2007.

Rob

quot;Narnimarquot; gt; wrote in message
...
gt;
gt; I want tick/untick when I mouse click on this object same like in excel
gt; 2003. but this is not working. ow can I do it?
gt;
gt; quot;RobNquot; wrote:
gt;
gt;gt; Joergiman,
gt;gt;
gt;gt; On the Menu bar select Developer, then Insert and double click the
gt;gt; Checkbox
gt;gt; in the Form Controls section. (Or single click and draw the box where you
gt;gt; want it on the spreadsheet.
gt;gt;
gt;gt; Rob
gt;gt;
gt;gt; quot;Narnimarquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; How to insert a check box it in Excel 2007?
gt;gt; gt;
gt;gt; gt; quot;Norman Jonesquot; wrote:
gt;gt; gt;
gt;gt; gt;gt; Hi Joergiman,
gt;gt; gt;gt;
gt;gt; gt;gt; View | Toolbars | Forms | Double click the checkbox | click the
gt;gt; gt;gt; worksheet.
gt;gt; gt;gt; Click the toolbar checkbox | Close the toolbar
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt; ---
gt;gt; gt;gt; Regards,
gt;gt; gt;gt; Norman
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt; quot;joergiemanquot; gt; wrote in message
gt;gt; gt;gt; ...
gt;gt; gt;gt; gt;A want to insert a check box that can be toggled on and off by
gt;gt; gt;gt; gt;clicking
gt;gt; gt;gt; gt;on
gt;gt; gt;gt; gt;it.
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt;
gt;gt;
gt;gt;

Sorry, I had clicked activeX control. It works fine.

quot;RobNquot; wrote:

gt; Hope someone else can help....works fine on my Excel 2007.
gt;
gt; Rob
gt;
gt; quot;Narnimarquot; gt; wrote in message
gt; ...
gt; gt;
gt; gt; I want tick/untick when I mouse click on this object same like in excel
gt; gt; 2003. but this is not working. ow can I do it?
gt; gt;
gt; gt; quot;RobNquot; wrote:
gt; gt;
gt; gt;gt; Joergiman,
gt; gt;gt;
gt; gt;gt; On the Menu bar select Developer, then Insert and double click the
gt; gt;gt; Checkbox
gt; gt;gt; in the Form Controls section. (Or single click and draw the box where you
gt; gt;gt; want it on the spreadsheet.
gt; gt;gt;
gt; gt;gt; Rob
gt; gt;gt;
gt; gt;gt; quot;Narnimarquot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt; How to insert a check box it in Excel 2007?
gt; gt;gt; gt;
gt; gt;gt; gt; quot;Norman Jonesquot; wrote:
gt; gt;gt; gt;
gt; gt;gt; gt;gt; Hi Joergiman,
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; View | Toolbars | Forms | Double click the checkbox | click the
gt; gt;gt; gt;gt; worksheet.
gt; gt;gt; gt;gt; Click the toolbar checkbox | Close the toolbar
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; ---
gt; gt;gt; gt;gt; Regards,
gt; gt;gt; gt;gt; Norman
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; quot;joergiemanquot; gt; wrote in message
gt; gt;gt; gt;gt; ...
gt; gt;gt; gt;gt; gt;A want to insert a check box that can be toggled on and off by
gt; gt;gt; gt;gt; gt;clicking
gt; gt;gt; gt;gt; gt;on
gt; gt;gt; gt;gt; gt;it.
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;
gt;

I want to insert a simple check box in my worksheets, I have tried to follow
your instructions but when I click on quot;Viewquot; I can't find quot;Toolbarsquot; and the
next steps, I'm new to Office 07 and I have looked high and low for the
toolbar after selecting the View Tab.quot;joergiemanquot; wrote:

gt; A want to insert a check box that can be toggled on and off by clicking on it.

Another question. How to create a x mark in the check box instead of tick

quot;RobNquot; wrote:

gt; Joergiman,
gt;
gt; On the Menu bar select Developer, then Insert and double click the Checkbox
gt; in the Form Controls section. (Or single click and draw the box where you
gt; want it on the spreadsheet.
gt;
gt; Rob
gt;
gt; quot;Narnimarquot; gt; wrote in message
gt; ...
gt; gt; How to insert a check box it in Excel 2007?
gt; gt;
gt; gt; quot;Norman Jonesquot; wrote:
gt; gt;
gt; gt;gt; Hi Joergiman,
gt; gt;gt;
gt; gt;gt; View | Toolbars | Forms | Double click the checkbox | click the
gt; gt;gt; worksheet.
gt; gt;gt; Click the toolbar checkbox | Close the toolbar
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; ---
gt; gt;gt; Regards,
gt; gt;gt; Norman
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; quot;joergiemanquot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt;A want to insert a check box that can be toggled on and off by clicking
gt; gt;gt; gt;on
gt; gt;gt; gt;it.
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;

Thanks but still i wonder. I want that in cells means mnay cells. and after
that too there comes check box written in the right left corner. How can we
remove it??

quot;Norman Jonesquot; wrote:

gt; Hi Joergiman,
gt;
gt; View | Toolbars | Forms | Double click the checkbox | click the worksheet.
gt; Click the toolbar checkbox | Close the toolbar
gt;
gt;
gt; ---
gt; Regards,
gt; Norman
gt;
gt;
gt; quot;joergiemanquot; gt; wrote in message
gt; ...
gt; gt;A want to insert a check box that can be toggled on and off by clicking on
gt; gt;it.
gt;
gt;
gt;