Change a color of a single cell in excel 07 by using a kitchen timer style time frame.

Author Message
Lost in Excel 07

  • Total Posts : 3
  • Scores: 0
  • Reward points : 0
  • Joined: 5/19/2010
  • Status: offline
Change a color of a single cell in excel 07 by using a kitchen timer style time frame. Wednesday, May 19, 2010 1:29 PM (permalink)
0
Excel 07, MS 07, I need to change the color of a single cell in excel, by clicking on it and having a timer run in the background that will actuate a color change, yellow to red, of that cell after a preferred time frame, like 30 min's.  Also I need the time, say 12:35am, to be shown in that cell at the time of the initial click.   
 
Use: someone go’s on break for 30min. I need to insure they return on time, if not the color of a cell changes to red.      
 
A second click on the cell changes it to green if time has not elapsed.  This part is not critical.
 
Anyone up for a challenge? 
 
 
Thanks in advance..
 
Lost in Excel 07
 
 
#1
    ebgreen

    • Total Posts : 8219
    • Scores: 98
    • Reward points : 0
    • Joined: 7/12/2005
    • Status: offline
    Re:Change a color of a single cell in excel 07 by using a kitchen timer style time frame. Thursday, May 20, 2010 12:53 AM (permalink)
    0
    To me this sounds like it would be better to do in VBA not VBScript. The two are not the same. Which do you want to actually use?
    "... when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick
    Goog places to start:http://www.visualbasicscript.com/m_24727/tm.htm
    http://www.visualbasicscript.com/m_47117/tm.htm
     
    #2
      Lost in Excel 07

      • Total Posts : 3
      • Scores: 0
      • Reward points : 0
      • Joined: 5/19/2010
      • Status: offline
      Re:Change a color of a single cell in excel 07 by using a kitchen timer style time frame. Thursday, May 20, 2010 11:52 AM (permalink)
      0
      I really don't have a clue,  but I will look at them..
       
      As I said in my introduction:
      "Just starting out on your tundra of knowledge and will need some help in VB /excel 07, but more of that later.  Introduction, as a user of MS products, I get myself in more trouble because I think of what I want to do but don't know enough to accomplish my thoughts.    Hope you can/will help me in my wicked ways.. "
       
      I don't use VB as much as I have in the past, so I'm losing my grip. Yes on reality and VB.. LOL.. 
       
      Thanks..
      <message edited by Lost in Excel 07 on Thursday, May 20, 2010 11:55 AM>
       
      #3
        ebgreen

        • Total Posts : 8219
        • Scores: 98
        • Reward points : 0
        • Joined: 7/12/2005
        • Status: offline
        Re:Change a color of a single cell in excel 07 by using a kitchen timer style time frame. Friday, May 21, 2010 12:30 AM (permalink)
        0
        For most Office automation the first step is to record a macro of any actions that you can. That gives you a starting point for your code.
        "... when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick
        Goog places to start:http://www.visualbasicscript.com/m_24727/tm.htm
        http://www.visualbasicscript.com/m_47117/tm.htm
         
        #4

          Online Bookmarks Sharing: Share/Bookmark

          Jump to:

          Current active users

          There are 0 members and 1 guests.

          Icon Legend and Permission

          • New Messages
          • No New Messages
          • Hot Topic w/ New Messages
          • Hot Topic w/o New Messages
          • Locked w/ New Messages
          • Locked w/o New Messages
          • Read Message
          • Post New Thread
          • Reply to message
          • Post New Poll
          • Submit Vote
          • Post reward post
          • Delete my own posts
          • Delete my own threads
          • Rate post

          2000-2012 ASPPlayground.NET Forum Version 3.9