Using Checkboxes in Excel

[spartikus]

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?

[Toppers]

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
>
>

[Doug Glancy]

spartikus,

I would heartily second Topper's suggestion. It's hard to work with all
those checkboxes!

hth,

Doug

"Toppers" <[email protected]> wrote in message
news:[email protected]...
> 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
>>
>>

[spartikus]

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?

[Doug Glancy]

spartikus,

Yes, that's it.

Doug

"spartikus" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>