Hi there,

as a beginner in VBA, I need a lot of help with the following problem:

I created a workbook with several sheets, the user can switch sheets by using a button on a sheet. So far this works ok. Next I would like to use a countdown timer on, let's say sheet 3. The timer must start as soon as the user pushes the button that opens sheet 3. The timer needs to countdown from 30 minutes to 0, so the user has no more than 30 minutes to stay on sheet 3. The minutes left must be visible in, lets say cell A1 on sheet 3. During the countdown, the user must be able to solve some problems presented on sheet 3, so events must be possible within the 30 minutes. When the time is over, sheet 3 must close (not visible) and another sheet, lets say sheet 5, becomes visible.

I have no idea how tot put this in proper VBA code and where and how to place this code in the workbook. Please, can you help me with this?

Peter