+ Reply to Thread
Results 1 to 3 of 3

VBA code for Traffic light system

  1. #1
    Registered User
    Join Date
    11-03-2015
    Location
    Manchester, England
    MS-Off Ver
    7
    Posts
    2

    VBA code for Traffic light system

    I have a worksheet with a series of boxes and data entry points that are completed by the user in a specific order. We operate our environment with manual (F9) calculation updates and would prefer this to continue, however we need this latest sheet to recalculate after some of the steps prior to moving onto the next step (so that new data can be brought up based on previous data entered). Although most of the calculations are fairly quick, the more complicated ones can take a few seconds and there is a risk that the user enters data prematurely in the next box stopping the calculation process. I would therefore like to have a traffic light system on my worksheet to show:

    a) when the worksheet is calculating (Red Light)
    b) when I need to press F9 to update the calculations (amber light) and
    c) a Green light to say that the worksheet is calculated / up-to-date.

    I have excel 2010 and windows 7. I am new to vba and have desperately tried to find a code for this but cannot find anything in existence. Could anyone help me with a vba code (or a cell formula) to display this?

    Your help and advice would be really appreciated

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: VBA code for Traffic light system

    Quote Originally Posted by slinney View Post
    I have a worksheet with a series of boxes and data entry points
    What kind of "boxes"? Do you mean an AciveX TextBox?


    Quote Originally Posted by slinney View Post
    there is a risk that the user enters data prematurely in the next box stopping the calculation process.
    When Excel is calculating, the user cannot enter new values. So I don't understand how this is working for you?
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Registered User
    Join Date
    11-03-2015
    Location
    Manchester, England
    MS-Off Ver
    7
    Posts
    2

    Re: VBA code for Traffic light system

    sorry by boxes, I mean cells (just formatted like a box)
    If excel is calculating and we click in another cell it stops the calculating process

    Can nobody help?
    Last edited by slinney; 11-24-2015 at 06:04 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Conditional Formatting of dates using a traffic light system
    By Taffia in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-10-2019, 01:44 AM
  2. Traffic Light Chart
    By YorkeG in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 07-16-2015, 12:11 PM
  3. conditional formatting a due date with a traffic light system
    By rocket01 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-08-2015, 05:11 PM
  4. Conditional Formating > Traffic Light System for Date Ranges PLS HELP
    By Dutchie12 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-11-2014, 07:36 AM
  5. [SOLVED] Traffic Light system to identify a due date HELP
    By mbaughuk in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-03-2013, 01:35 PM
  6. [SOLVED] Traffic Light Icons
    By Blake 7 in forum Excel General
    Replies: 4
    Last Post: 02-11-2013, 10:12 PM
  7. Please help with traffic light problem.
    By t0n1c in forum Excel General
    Replies: 0
    Last Post: 01-20-2012, 12:13 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1