continuous process

  1. T

    How to create a continuous VBA program sub

    I am uploading live-data from bloomberg onto excel, and that data contains the date/time (i.e. 7/8/14 6:01pm) and a stock price. Since it goes in real time, after each previous date/time and stock price, whenever new data becomes available, it is constantly being added below the previous...
  2. J

    Edit this code to continuously run Macro? : )

    Current, what i'm doing is i want Cell A6 in Worksheet("Compensation") to be show up looking like "less Items # 1,5,4,6." Those numbers actually correspond to cell values in Column A in another worksheet known as "Cap. Rec." when Column E holds value R. What I actually got was the formula only...
  3. M

    Changing Value

    I am creating a template for a report based tool. I have different return in column A (in the sense that Toronto or Houston, etc may come in different amounts based on my data). I need a formula that I can drag down 200 rows and will not have to worry about my output into column D. Please...
  4. A

    Continuous Macro to rid screen blinking

    This may be a bit of a complicated message, but I currently have a macro that pulls in data via XML every 15 secs. I am using the screenupdating = false to stop the updating, but every time my macro runs, at the end, the screen will blink. I need help figuring out a way to get rid of that...
  5. T

    how to jump out of a continuously running process?

    I have an application that I want to read a digital volt meter (DVM) in two ways. The first way is to continuously read the DVM and display the voltage on the screen. The second is to only read the DVM a single time when I hit a button. I can get both to run independently but I can't get...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top