Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Checkboxes in Excel
I am adding a TAX column in a spreadsheet I created and in that column want to add a checkbox for each entry. If the box is checked it mean the item is calculated with tax and if not check it means that ta should not be applied to the item. I don't know how to program o write a code that will make the checkbox do that. Can someone help m get started -- spartiku ----------------------------------------------------------------------- spartikus's Profile: http://www.excelforum.com/member.php...fo&userid=3227 View this thread: http://www.excelforum.com/showthread.php?threadid=53600 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Checkboxes in Excel
Just a thought ....
It might be easier just to add a YES/NO data validation to the column rather use checkboxes. "spartikus" wrote: I am adding a TAX column in a spreadsheet I created and in that column I want to add a checkbox for each entry. If the box is checked it means the item is calculated with tax and if not check it means that tax should not be applied to the item. I don't know how to program or write a code that will make the checkbox do that. Can someone help me get started? -- spartikus ------------------------------------------------------------------------ spartikus's Profile: http://www.excelforum.com/member.php...o&userid=32272 View this thread: http://www.excelforum.com/showthread...hreadid=536005 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Checkboxes in Excel
spartikus,
I would heartily second Topper's suggestion. It's hard to work with all those checkboxes! hth, Doug "Toppers" wrote in message ... Just a thought .... It might be easier just to add a YES/NO data validation to the column rather use checkboxes. "spartikus" wrote: I am adding a TAX column in a spreadsheet I created and in that column I want to add a checkbox for each entry. If the box is checked it means the item is calculated with tax and if not check it means that tax should not be applied to the item. I don't know how to program or write a code that will make the checkbox do that. Can someone help me get started? -- spartikus ------------------------------------------------------------------------ spartikus's Profile: http://www.excelforum.com/member.php...o&userid=32272 View this thread: http://www.excelforum.com/showthread...hreadid=536005 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Checkboxes in Excel
Thanks for the suggestion. I ended up just creating a tax column with a Y/N option and then created a formula that would add or subtract the tax based on the Y/N value. Is that essential what you were suggesting to do? -- spartikus ------------------------------------------------------------------------ spartikus's Profile: http://www.excelforum.com/member.php...o&userid=32272 View this thread: http://www.excelforum.com/showthread...hreadid=536005 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Checkboxes in Excel
spartikus,
Yes, that's it. Doug "spartikus" wrote in message ... Thanks for the suggestion. I ended up just creating a tax column with a Y/N option and then created a formula that would add or subtract the tax based on the Y/N value. Is that essential what you were suggesting to do? -- spartikus ------------------------------------------------------------------------ spartikus's Profile: http://www.excelforum.com/member.php...o&userid=32272 View this thread: http://www.excelforum.com/showthread...hreadid=536005 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need help with excel and checkboxes | Excel Discussion (Misc queries) | |||
How do I set up checkboxes in excel? | Excel Discussion (Misc queries) | |||
Excel Checkboxes | Excel Discussion (Misc queries) | |||
Checkboxes in Excel - Please Help! | Excel Discussion (Misc queries) | |||
Excel VBA array of checkboxes | Excel Programming |