Home |
Search |
Today's Posts |
#1
|
|||
|
|||
tick box
Hello
I am making a timesheet to record working hours Would it be possible to use a tick box ( I know how to add this to a cell) to return a particular value in another cell? I would like a user to be able to tick a box to indicate annual leave lets say in cell B9 and by doing so return a value of 8 hours worked that day in cell B10. Not ticking the box returns value of zero, or rather adds zero to B10 (B10 currently has the formula to total the hours worked for that day) many thanks CH! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
tick a reference automatically | Excel Discussion (Misc queries) | |||
how to hide section of worksheet based on a condition (e.g. tick . | Excel Discussion (Misc queries) | |||
Setting Major tick to none on charts is not working, is it a bug? | Charts and Charting in Excel | |||
how I can insert a "tick" symbol | Excel Worksheet Functions | |||
Scatter chart x axis tick mark lables | Charts and Charting in Excel |