in
All Tags » VBA » error (RSS)

Browse by Tags

  • runtime error 1004 in excel vba

    Would anyone have even the slightest idea what might be going wrong with the following code? Sometimes it works fine, but most of the time I get a 'runtime 1004: application-defined or object-defined error' NOTES: -When stepping through application, runtime 1004 error is raised on the 'End...
    Posted to Miscellaneous (Forum) by microsoft on 05-28-2010

  • Sheets referenced in excel formula within vba macro producing error!!

    OK, where to start.. As you can probablly see from the attached code I only started learning VBA a few days ago, and the following code has been bodged together so is a bit of a mess. Anyway... I receive a new price list from my supplier every day with column A having item name, column B having shipping...
    Posted to Visual Interdev (Forum) by microsoft on 11-28-2009

  • Sheets referenced in excel formula within vba macro producing error!!

    OK, where to start.. As you can probablly see from the attached code I only started learning VBA a few days ago, and the following code has been bodged together so is a bit of a mess. Anyway... I receive a new price list from my supplier every day with column A having item name, column B having shipping...
    Posted to Visual Interdev (Forum) by microsoft on 11-28-2009

  • Disable error message in VBA

    I can never remember how to turn off the error messages in VBA while typing. I know there is a setting that will let the text become red but not pop up the error message. Can somebody help me find it? Thanks in advance.
    Posted to Access (Forum) by microsoft on 10-04-2009

  • SQL - ODBC - VBA in Excel - Run-time error '1004'

    Hi, I built a code that executes an SQL code over an ODCB connection. My problem is that this code is working well on my computer but isn't working on 6 others similar computer that I tried my code. Error message : Run-Time Error '1004'; Application-defined or object-defined error. This appear...
    Posted to Excel (Forum) by microsoft on 08-13-2009

  • ListBox VBA code works great on all but ONE computer-- HELP!!

    I have a small text box above a SQL-driven list of properties in a ListBox. When you type in a letter or two, it evaluates the contents of the text box and takes you right to the first instance of a property that starts with the letters in the text box. The code works great. But then, recently one of...
    Posted to Access (Forum) by microsoft on 08-10-2009

  • Detect VBA Subroutine or Function Caller

    From within a VBA Sub or Function how can one determine the name of the subroutine or function that called it? [Could also have been called by assigning a macro to an object within an excel worksheet - this can be easilly determined by using application.caller. However, this produces an Error 2023 if...
    Posted to Excel (Forum) by microsoft on 08-09-2009

  • VBA Vlookup error 2042

    Hi, I have been having trouble with getting my vlookup to work in vba. I am trying to return a value from a table in another spreadsheet; I manually did the vlookup then used the code generated to produce the range. Below is the vba I have been using: actualrate.Value = Application.VLookup(Vr1, Range...
    Posted to Excel (Forum) by microsoft on 08-09-2009

  • I got and answer to one of my question but can get it to work

    I cant get the VBA to work in my access database. This was the answer from ajkamp Comment from ajkamp Date: 05/12/2006 04:22PM EDT Comment Once you have the data in your query and the report is formatted as you want, you'll need to write some VBA to handle the export that will look something like...
    Posted to Access (Forum) by microsoft on 07-16-2009

  • Invalid Picture Error on VBA form in Excel

    This one has me absolutely baffled. I have been working on this same enhanced Excel application for months. About two weeks ago I added a splash screen that displays using the workbooks "open" event and uses the ontimer method to close itself and finish loading. The splash screen form has an...
    Posted to Microsoft Office (Forum) by microsoft on 07-11-2009
Page 1 of 3 (24 items) 1 2 3 Next >