#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10
Default Check Boxes

What are the differences between Check boxes made by the Forms toolbar and
Check boxes made by the Control toolbox?
I would also like to know if there is a quick way of putting a whole column
or row of check boxes or maybe copying a whole column of boxes to a different
column?
Thanks in appreciation.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Check Boxes

there are other options as well, what do you want to happen when a checkbox
is checked?

"MACAVITY500" wrote:

What are the differences between Check boxes made by the Forms toolbar and
Check boxes made by the Control toolbox?
I would also like to know if there is a quick way of putting a whole column
or row of check boxes or maybe copying a whole column of boxes to a different
column?
Thanks in appreciation.

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 194
Default Check Boxes

MACAVITY500

Check "Help" on the difference between the two types. They both have their
attributes and depending on what your goal is would determine which one to
use. But I can help you put in a column or row without code. (There is also
code out there that will do it). Forms: place the first one where you want
it relative to the cell, but make sure you can still get to the drag handle
on the cell so don't cover that up. Once it is where and the way you want
just get the drag bar and drag which ever direction you want, row or column.
These can be linked to the cell they are in (or any cell for that matter).
DO NOT link them before you drag because it will also drag that link. Do
your linking after if you are going to link to a cell. The control tool box
is done much the same way with the exception that you must be in design mode
to drag them. While in design mode you can set more properties and do
different things then with the forms checkbox.

If all you want is a check mark in a cell there are ways of doing that. It
requires code and if that will work for you post back and I think I can help
with that.

Does this help you?

Mike Rogers

"MACAVITY500" wrote:

What are the differences between Check boxes made by the Forms toolbar and
Check boxes made by the Control toolbox?
I would also like to know if there is a quick way of putting a whole column
or row of check boxes or maybe copying a whole column of boxes to a different
column?
Thanks in appreciation.

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10
Default Check Boxes

Thank you Mike that is really helpful

"Mike Rogers" wrote:

MACAVITY500

Check "Help" on the difference between the two types. They both have their
attributes and depending on what your goal is would determine which one to
use. But I can help you put in a column or row without code. (There is also
code out there that will do it). Forms: place the first one where you want
it relative to the cell, but make sure you can still get to the drag handle
on the cell so don't cover that up. Once it is where and the way you want
just get the drag bar and drag which ever direction you want, row or column.
These can be linked to the cell they are in (or any cell for that matter).
DO NOT link them before you drag because it will also drag that link. Do
your linking after if you are going to link to a cell. The control tool box
is done much the same way with the exception that you must be in design mode
to drag them. While in design mode you can set more properties and do
different things then with the forms checkbox.

If all you want is a check mark in a cell there are ways of doing that. It
requires code and if that will work for you post back and I think I can help
with that.

Does this help you?

Mike Rogers

"MACAVITY500" wrote:

What are the differences between Check boxes made by the Forms toolbar and
Check boxes made by the Control toolbox?
I would also like to know if there is a quick way of putting a whole column
or row of check boxes or maybe copying a whole column of boxes to a different
column?
Thanks in appreciation.

  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 194
Default Check Boxes

MACAVITY500

Thank you for the post back it is always appreciated!!

Mike Rogers

"MACAVITY500" wrote:

Thank you Mike that is really helpful

"Mike Rogers" wrote:

MACAVITY500

Check "Help" on the difference between the two types. They both have their
attributes and depending on what your goal is would determine which one to
use. But I can help you put in a column or row without code. (There is also
code out there that will do it). Forms: place the first one where you want
it relative to the cell, but make sure you can still get to the drag handle
on the cell so don't cover that up. Once it is where and the way you want
just get the drag bar and drag which ever direction you want, row or column.
These can be linked to the cell they are in (or any cell for that matter).
DO NOT link them before you drag because it will also drag that link. Do
your linking after if you are going to link to a cell. The control tool box
is done much the same way with the exception that you must be in design mode
to drag them. While in design mode you can set more properties and do
different things then with the forms checkbox.

If all you want is a check mark in a cell there are ways of doing that. It
requires code and if that will work for you post back and I think I can help
with that.

Does this help you?

Mike Rogers

"MACAVITY500" wrote:

What are the differences between Check boxes made by the Forms toolbar and
Check boxes made by the Control toolbox?
I would also like to know if there is a quick way of putting a whole column
or row of check boxes or maybe copying a whole column of boxes to a different
column?
Thanks in appreciation.

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
Tracking Check Boxes deerhunter98 Excel Worksheet Functions 1 October 30th 06 08:07 PM
Linked Check Boxes blueegypt Excel Discussion (Misc queries) 4 May 12th 06 10:36 PM
Can one cell hold multiple check boxes (and then sort based off e. OT Excel Discussion (Misc queries) 1 March 29th 06 07:32 PM
Selecting Check Boxes shezzer_1972 Excel Discussion (Misc queries) 7 May 11th 05 01:10 AM
How to align check boxes on an Excel sheet? CC Excel Worksheet Functions 2 February 16th 05 03:27 PM


All times are GMT +1. The time now is 11:22 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"