Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
joergieman
 
Posts: n/a
Default How do create a check box

A want to insert a check box that can be toggled on and off by clicking on it.
  #2   Report Post  
Posted to microsoft.public.excel.misc
Norman Jones
 
Posts: n/a
Default 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.



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 132
Default 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.




  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 230
Default 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.






  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 132
Default 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.








  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 230
Default 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.









  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 132
Default 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.










  #8   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 142
Default 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.

  #9   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 132
Default 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.






  #10   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default 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.




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
checking that cells have a value before the workbook will close kcdonaldson Excel Worksheet Functions 8 December 5th 05 04:57 PM
Creating a Check Digit Ilan Charts and Charting in Excel 1 December 3rd 05 12:43 PM
how do I name a check box Flower Power Excel Discussion (Misc queries) 1 November 28th 05 04:06 AM
check box, so when you click on it it inserts a check mark into t. Steve Excel Discussion (Misc queries) 2 April 13th 05 09:12 PM
Using a Check Box as a control item Dan G Excel Discussion (Misc queries) 2 December 14th 04 07:59 PM


All times are GMT +1. The time now is 05:16 AM.

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"