event handling

  1. R

    downloading completed?

    My programme causes a specific site to download a csv workbook. (It does this by sending keystrokes, and strings). It works perfectly well, but I then want to analyse the sheets. Now I cannot do this until I know the download has completed; but it will not complete while excel is running. So...
  2. T

    Event for when a Named Range is created

    Is there a Excel VBA event that is triggered when someone creates a named range (for example via Name Manager on the Formulas tab)?
  3. H

    Running an Event Handling Macro

    Hello, I have a query pulling in data from an external database. In the same worksheet, I have cells equaling cells in the query table. When data in the query changes, the equals formulas #ref out. I am trying to create a macro that will copy the formulas down whenever the query table is...
  4. S

    Listview add at run time with class module for event handling

    I'm having problems deploying a vba project on PCs throughout my organisation due to differences in windows configurations (I think). I have checked that MSCOMCTL.ocx is available on each PC and the listview control is available in the form controls menu (tools). As a side note, when I tried...
  5. T

    Excel 2007 - Worksheet Activate Event Problem

    When this event is triggered, I get a message "Object or Library Not Found" as if it is looking for the VBA Object library, which should have been loaded. The worksheet name is "Input|Output". Is there a conflict between two events? I attached the code below for help Thanks! Private Sub...
  6. H

    How to deal with two charts and their events

    Hello, I am working on an adapted version of the MouseMove Interactive chart (Interactive Chart in VBA using Mouse Move Event | Excel & VBA – Databison). My goal is to have 5 seperate charts embedded on one worksheet that all have the hover capability. I have sucessfully got one chart to use the...
  7. D

    How to catch copy / paste event

    First of all I want to thank you guys for this forum. Helped me to many times! But now I'm pretty stuck on one problem. My workbook use protection. Special cells are locked if not empty. I use WorkSheet_Change(), when some cell is changed, every locked cell will be protected and need to...
  8. B

    Excel 2007 Event Handler and Time Entry problem

    I'm having trouble entering time without using ":" as a delimiter. I just watched the Mr Excel video on Event Handlers: http://www.youtube.com/user/bjele123#p/c/42/FVTB6ruazJU<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> ... and was psyched to...

Some videos you may like

This Week's Hot Topics