Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi
I am totally new to VBA and really need to do some help! I am writing an excel worksheet to send to students practising for multi choice exams. They are supposed to press a button when they start the paper which will then record the start time in a box. I have written a macro that does this and protects the cell so that the time cannot then be changed but I want it to automatically run if they answer any questions without pressing the start button. My idea for doing this is to use the worksheet_change function to watch the cells into which the answers would go (namely C12:F37) and if any of those are changed run the starttime macro. Can anyone tell me how to do this or give me some code that would work. Many Thanks Jonathan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Finding min/max of adjacent data in a range of cells | Excel Worksheet Functions | |||
save original data after macro is run again | New Users to Excel | |||
Counting empty cells within a range of cells | New Users to Excel | |||
data range | Excel Discussion (Misc queries) | |||
Macro does not run when data refreshed | Excel Discussion (Misc queries) |