Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
adding multiple checkboxes in a single cell | New Users to Excel | |||
Creating multiple checkboxes in a cell | Setting up and Configuration of Excel | |||
CREATING MULTIPLE CHECKBOXES IN SINGLE CELLS | Excel Discussion (Misc queries) | |||
Adding multiple checkboxes | Excel Discussion (Misc queries) | |||
Multiple Checkboxes Shortcut? | Excel Discussion (Misc queries) |