Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
attendance sheet
I need to mark attendance for a class running for 3 months.
anyone an attendance sheet for 15 people where i can just check on each box if they are present. this should also have a pie chart where each person's participation is shown as a percentage to all |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
attendance sheet
Put the names in A2 down, the dates in B1 across to say CO1, and then
This works by double-clicking in a cell, and toggles the check-mark. Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) Const WS_RANGE As String = "B2:CO16" '<=== change to suit On Error GoTo err_handler Application.EnableEvents = False If Not Application.Intersect(Target, Range(WS_RANGE)) Is Nothing Then With Target .Font.Name = "Marlett" Select Case .Value Case "": .Value = "a" Case "a": .Value = "" End Select End With End If err_handler: Application.EnableEvents = True End Sub This is worksheet event code, which means that it needs to be placed in the appropriate worksheet code module, not a standard code module. To do this, right-click on the sheet tab, select the View Code option from the menu, and paste the code in. then just chart that data. -- __________________________________ HTH Bob "Lynn" wrote in message ... I need to mark attendance for a class running for 3 months. anyone an attendance sheet for 15 people where i can just check on each box if they are present. this should also have a pie chart where each person's participation is shown as a percentage to all |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
attendance sheet
There are some free templates you can download from this site which may be of
some help to you. http://www.vertex42.com/ExcelTemplat...-tracking.html -- jb "Lynn" wrote: I need to mark attendance for a class running for 3 months. anyone an attendance sheet for 15 people where i can just check on each box if they are present. this should also have a pie chart where each person's participation is shown as a percentage to all |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to create Login & Log out Spread sheet in Excel with automated Attendance sheet | Excel Worksheet Functions | |||
Help creating attendance sheet. | New Users to Excel | |||
Attendance Sheet. | Excel Discussion (Misc queries) | |||
attendance sheet | Excel Worksheet Functions | |||
attendance sheet to add time but not..... | Excel Worksheet Functions |