ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   check boxes for fee total (https://www.excelbanter.com/excel-worksheet-functions/177888-check-boxes-fee-total.html)

Tomcat213

check boxes for fee total
 
I want to link check boxes to student fees. Each check box would equal a
specific dollar amount. Can this be done to give a total dollar amount at
the end of the check boxes?

Billy Liddel

check boxes for fee total
 
You do not have to use checkboxes for this. Try Data Validation. Saya you
have a list of fees in the book named Amounts.

Choose Data, Validation, in the Allow drop-down choose List, in the source
type =Amounts and click OK.

When you enter the validation area you will see an arrow; click on this and
choose a figure from the list.

You can enter a normal sum below the area.

Regards
Peter

"Tomcat213" wrote:

I want to link check boxes to student fees. Each check box would equal a
specific dollar amount. Can this be done to give a total dollar amount at
the end of the check boxes?



All times are GMT +1. The time now is 05:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com