ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do create a check box (https://www.excelbanter.com/excel-discussion-misc-queries/71006-how-do-create-check-box.html)

joergieman

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

Norman Jones

How do create a check box
 
Hi Joergiman,

View | Toolbars | Forms | Double click the checkbox | click the worksheet.
Click the toolbar checkbox | Close the toolbar


---
Regards,
Norman


"joergieman" wrote in message
...
A want to insert a check box that can be toggled on and off by clicking on
it.




Narnimar

How do create a check box
 
How to insert a check box it in Excel 2007?

"Norman Jones" wrote:

Hi Joergiman,

View | Toolbars | Forms | Double click the checkbox | click the worksheet.
Click the toolbar checkbox | Close the toolbar


---
Regards,
Norman


"joergieman" wrote in message
...
A want to insert a check box that can be toggled on and off by clicking on
it.





RobN[_2_]

How do create a check box
 
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

"Narnimar" wrote in message
...
How to insert a check box it in Excel 2007?

"Norman Jones" wrote:

Hi Joergiman,

View | Toolbars | Forms | Double click the checkbox | click the
worksheet.
Click the toolbar checkbox | Close the toolbar


---
Regards,
Norman


"joergieman" wrote in message
...
A want to insert a check box that can be toggled on and off by clicking
on
it.







Narnimar

How do create a check box
 

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?

"RobN" wrote:

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

"Narnimar" wrote in message
...
How to insert a check box it in Excel 2007?

"Norman Jones" wrote:

Hi Joergiman,

View | Toolbars | Forms | Double click the checkbox | click the
worksheet.
Click the toolbar checkbox | Close the toolbar


---
Regards,
Norman


"joergieman" wrote in message
...
A want to insert a check box that can be toggled on and off by clicking
on
it.







RobN[_2_]

How do create a check box
 
Hope someone else can help....works fine on my Excel 2007.

Rob

"Narnimar" wrote in message
...

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?

"RobN" wrote:

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

"Narnimar" wrote in message
...
How to insert a check box it in Excel 2007?

"Norman Jones" wrote:

Hi Joergiman,

View | Toolbars | Forms | Double click the checkbox | click the
worksheet.
Click the toolbar checkbox | Close the toolbar


---
Regards,
Norman


"joergieman" wrote in message
...
A want to insert a check box that can be toggled on and off by
clicking
on
it.










Narnimar

How do create a check box
 
Sorry, I had clicked activeX control. It works fine.

"RobN" wrote:

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

Rob

"Narnimar" wrote in message
...

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?

"RobN" wrote:

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

"Narnimar" wrote in message
...
How to insert a check box it in Excel 2007?

"Norman Jones" wrote:

Hi Joergiman,

View | Toolbars | Forms | Double click the checkbox | click the
worksheet.
Click the toolbar checkbox | Close the toolbar


---
Regards,
Norman


"joergieman" wrote in message
...
A want to insert a check box that can be toggled on and off by
clicking
on
it.











Jerry

How do create a check box
 
I want to insert a simple check box in my worksheets, I have tried to follow
your instructions but when I click on "View" I can't find "Toolbars" 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.


"joergieman" wrote:

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


Narnimar

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

"RobN" wrote:

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

"Narnimar" wrote in message
...
How to insert a check box it in Excel 2007?

"Norman Jones" wrote:

Hi Joergiman,

View | Toolbars | Forms | Double click the checkbox | click the
worksheet.
Click the toolbar checkbox | Close the toolbar


---
Regards,
Norman


"joergieman" wrote in message
...
A want to insert a check box that can be toggled on and off by clicking
on
it.







Chiran

How do create a check box
 
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??

"Norman Jones" wrote:

Hi Joergiman,

View | Toolbars | Forms | Double click the checkbox | click the worksheet.
Click the toolbar checkbox | Close the toolbar


---
Regards,
Norman


"joergieman" wrote in message
...
A want to insert a check box that can be toggled on and off by clicking on
it.






All times are GMT +1. The time now is 09:12 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com