#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 103
Default Multiple Checkboxes

I have a two fold question:

In my document I have worldwide data and the subsequent worksheets are the
continents broken out from that worldwide worksheet.

So first, I want checkboxes for each client (approx 600) and link them to
their corresponding rows. Is there any way that I can do this without going
into the checkbox properties feature and typing in the link, one by one?
I've tried cutting and pasting but it's not working.

My second question is: When this information is inserted onto the
corresponding continents worksheets, will the linkings stay correct and
adjust, as well?

Thanks!
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 611
Default Multiple Checkboxes

Annie,

I don't know of a way to replicate check boxes linked to individual rows. Consider using an
X or something in a cell instead. It's easy to test with a formula. If you really want to
get fancy, and can work with macros, we can give you a macro that the user can type anything
into the column, such as pressing the space bar, and the cell will get a check mark. Press
it again, and it clears the check mark.

--
Earl Kiosterud
www.smokeylake.com

Note: Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
-----------------------------------------------------------------------
"Annie" wrote in message
...
I have a two fold question:

In my document I have worldwide data and the subsequent worksheets are the
continents broken out from that worldwide worksheet.

So first, I want checkboxes for each client (approx 600) and link them to
their corresponding rows. Is there any way that I can do this without going
into the checkbox properties feature and typing in the link, one by one?
I've tried cutting and pasting but it's not working.

My second question is: When this information is inserted onto the
corresponding continents worksheets, will the linkings stay correct and
adjust, as well?

Thanks!



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 103
Default Multiple Checkboxes

Earl,

Thank you anyway. That's the way my company wants it, so I guess I have to
do it manually.

"Earl Kiosterud" wrote:

Annie,

I don't know of a way to replicate check boxes linked to individual rows. Consider using an
X or something in a cell instead. It's easy to test with a formula. If you really want to
get fancy, and can work with macros, we can give you a macro that the user can type anything
into the column, such as pressing the space bar, and the cell will get a check mark. Press
it again, and it clears the check mark.

--
Earl Kiosterud
www.smokeylake.com

Note: Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
-----------------------------------------------------------------------
"Annie" wrote in message
...
I have a two fold question:

In my document I have worldwide data and the subsequent worksheets are the
continents broken out from that worldwide worksheet.

So first, I want checkboxes for each client (approx 600) and link them to
their corresponding rows. Is there any way that I can do this without going
into the checkbox properties feature and typing in the link, one by one?
I've tried cutting and pasting but it's not working.

My second question is: When this information is inserted onto the
corresponding continents worksheets, will the linkings stay correct and
adjust, as well?

Thanks!




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
adding multiple checkboxes in a single cell Pat New Users to Excel 2 January 27th 07 03:27 AM
Creating multiple checkboxes in a cell Pat Setting up and Configuration of Excel 4 January 26th 07 06:36 PM
CREATING MULTIPLE CHECKBOXES IN SINGLE CELLS Pat Excel Discussion (Misc queries) 5 January 26th 07 06:03 PM
Adding multiple checkboxes timmeah4 Excel Discussion (Misc queries) 7 December 6th 06 02:48 PM
Multiple Checkboxes Shortcut? Jason Excel Discussion (Misc queries) 1 October 18th 05 08:08 PM


All times are GMT +1. The time now is 04:07 PM.

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"