Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Timed Interval Data Entry
Hi
I'm having trouble with a macro I need. I need a worksheet that allows users to enter a value (between 1 and 5) using a keypad, but only at certain time intervals. For example, every 2 minutes, the user gets a reminder (a flashing text box?) to input a value. the value is then input via the key pad and the 'flashing reminder' goes away. 2 minutes later, same thing, and so on for a specified time period until you have a list of numbers. My main problems are that although I can 'get by' in VBA I can't figure out how to: a) get a repeating flashing message reminder b) lock the data entry between input periods c) let the user enter data while a macro is running. Basic design is: <interval = 120 seconds <active_time = 10 seconds <end_time = 6000 seconds start_time wait interval do active_time tasks wait interval do active_time tasks etc.... until end_time active_time tasks { flash message box (or input box?) allow user to enter number via keypad store number in list stop flash message box increment cell position so that next input goes in new cell } Is that even possible? I've struggled for ages on this but my programming skills just aren't up to it. Thanks Conor |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Timed Interval Data Entry
Look at Chip Pearson's page on using Application.Ontime. The macro is not
running all the time, so that is part of the solution. http://www.cpearson.com/excel/ontime.htm You can use the code to protect and unprotect the sheet (possibly). -- Regards, Tom Ogilvy "Conor" wrote in message ... Hi I'm having trouble with a macro I need. I need a worksheet that allows users to enter a value (between 1 and 5) using a keypad, but only at certain time intervals. For example, every 2 minutes, the user gets a reminder (a flashing text box?) to input a value. the value is then input via the key pad and the 'flashing reminder' goes away. 2 minutes later, same thing, and so on for a specified time period until you have a list of numbers. My main problems are that although I can 'get by' in VBA I can't figure out how to: a) get a repeating flashing message reminder b) lock the data entry between input periods c) let the user enter data while a macro is running. Basic design is: <interval = 120 seconds <active_time = 10 seconds <end_time = 6000 seconds start_time wait interval do active_time tasks wait interval do active_time tasks etc.... until end_time active_time tasks { flash message box (or input box?) allow user to enter number via keypad store number in list stop flash message box increment cell position so that next input goes in new cell } Is that even possible? I've struggled for ages on this but my programming skills just aren't up to it. Thanks Conor |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time interval data and weighting | Excel Discussion (Misc queries) | |||
Averaging an interval of data | Excel Discussion (Misc queries) | |||
Data Entry Online, Data Format, Data Conversion and Data EntryServices through Data Entry Outsourcing | Excel Discussion (Misc queries) | |||
Grouping a Set of Data By Time Interval | Excel Discussion (Misc queries) | |||
internet connection via excel macro at timed intervels & save data to excel file. | Excel Worksheet Functions |