Macro/VBA to query clock before placing value in relevant cell.

Hi all,

This is my first post and may be a bit if a strange one. I have worked in education for a long time now and some time ago I created a fairly complex spreadsheet to monitor, track and report on pupil progress linked to specific criteria. The process has been designed to make the relevant data entry pretty much fool proof, leading to realistic analytical outcomes. I am now in my 8th version of this spreadsheet and am looking to make it even easier from the end user perspective. However, I'm not even sure if what I want to achieve is even possible, so any suggestions would be amazing.

I would like to know if is it possible for a macro/VBA to query real time and place a numeric entry in to appropriate cell? At the moment, when a user presses a specific Excel button a macro is activated which puts a numeric value in a specified cell (EG cell A1). If the button is pressed again, the value in that cell increases by 1. So far this is a relatively simple click counter process. What I would like to achieve is that when the button is pressed a macro/VBA code would then query the clock for current time and based on the reported time to place the value in one of a range of cells. For example: If the button is pressed at 13:00 the value is placed in cell A1, however, the same button, when pressed at 13:15 would place the value in cell B1.

I am by no means an Excel expert, but am familiar with general functions, formulas, macros and codes. However the answer to this particular problem eludes me! If anyone has a suggestion, or is even able to confirm if this is even possible, I would be eternally grateful!

Thanks in advance!

Please Login or Register  to view this content.

it depends what kind of button you choose.
The "me.cells(..." has to modify in "Activesheet.cells(..." or "sheets("Name of the sheet").cells(...."