+ Reply to Thread
Results 1 to 5 of 5

HELP! I have a VBA pop up window that keeps coming back

  1. #1
    Registered User
    Join Date
    06-17-2013
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    25

    HELP! I have a VBA pop up window that keeps coming back

    The blank vba pop with a red cross keeps showing and I cannot figure out why....
    Attached Images Attached Images

  2. #2
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: HELP! I have a VBA pop up window that keeps coming back

    Post your code / attach your workbook.
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

  3. #3
    Registered User
    Join Date
    06-17-2013
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    25

    Re: HELP! I have a VBA pop up window that keeps coming back

    Olly, thanks for your response. I am working with several workbooks opened in the same instance of excel and many macros are constantly running. Unfortunately I cannot post the files as they contain proprietary information. I would need some help on what to look for in my vba codes that could trigger this popup. Thanks!

  4. #4
    Registered User
    Join Date
    06-17-2013
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    25

    Re: HELP! I have a VBA pop up window that keeps coming back

    It usually happens when I click on another application and then come back to excel.

  5. #5
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: HELP! I have a VBA pop up window that keeps coming back

    Start with a process of elimination. Work out WHICH workbook is causing the error. Close all others.

    Now work out which code is causing the error. Post that code.

    Just a hunch... Do any of the workbooks contain ribbon customisations? Were these workbooks created in 2007, and you are using 2010?

+ 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. VLOOKUP coming back as #N/A (some of the time)
    By Clanty in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 05-25-2016, 03:13 PM
  2. [SOLVED] IF AND Functions coming back as False
    By Tordah in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-03-2015, 05:22 PM
  3. VLOOKUP Formula coming back with NA#
    By monza2 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 10-18-2012, 01:38 AM
  4. Macro coming back with Run Time Error
    By amasulli in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-14-2012, 10:44 AM
  5. [SOLVED] emailed docs coming back in different format
    By JL Adamson in forum Excel General
    Replies: 0
    Last Post: 10-05-2005, 12:05 PM
  6. Assigning Macros to Buttons in Excel:window is not coming up
    By Ronnie in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-20-2005, 04:05 PM
  7. Replies: 1
    Last Post: 06-03-2005, 02:05 PM

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