Ok, i know this will take VB code. I am not a VB coder by any means. I am a Java coder.

Here is what i am looking to do.......

0 - 50 in a drop down menu. I need to increment 1 at a time when i choose a number every 5 minutes until 50 and stop. When i chose a number i need it to ask me for the timer settings. Example: 3 minutes until next increment. I need this in a popup after choosing the number. But it must be in minutes.....

This needs to work offline aswell. Using the System's time so when i close the excel doc and reopen it 2 hours later it takes in consideration that 2 hours has gone by and calculates correctly.


If anyone could help me get on the right track that would be great.