1. M

    User Form controls still executing after Unload

    I am using a UF that the user enters details on that need to be appended to a range in a worksheet. Once the data has been added and pasted into a holding worksheet, the UF is closed via an Unload commande but when some of the non UF code is executing, the code for some controls are executing...
  2. N

    Executing Macro by clicking Cell Contain.

    Dear Sir, I Want to execute Micro by clicking Cell "A3" Containt. Can It Possibel.
  3. T

    Worksheet calculate Event - Macro not working

    Hello, I have a pretty big file to run and attempting to have a "please wait" pop up windows whenever the sheet recalculate. However, the code I pasted below does not seem to work. When I see "Calculating ..4 processors" in the bottom right of the page, the pop up window and worst the code is...
  4. A

    Code behind tab not executing

    For some reason, all code (i.e., onchange, worksheet_activate, worksheet_deactivate) behind my tabs are not executing automatically. I know that they run, bc, I can step in them to execute them. Also all of my other code runs as expected. Could there actually be a setting that is preventing...
  5. T

    Is there a way to save a copy of a workbook in VBA?

    If you do a "Save As" the workbook you are working in is not left open, instead what is left open is the new workbook with the new name. What I'd like is for the original workbook to remain open, but that a copy of it is tucked off somewhere. In fact i don't really want that copy open at all...

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...