+ Reply to Thread
Results 1 to 2 of 2

Run-time Error 32809: Application-defined Or Object-defined Error

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    02-20-2009
    Location
    bristol
    MS-Off Ver
    Excel 2003
    Posts
    883

    Run-time Error 32809: Application-defined Or Object-defined Error

    Hi All

    I am getting the above error message but not on all the PCs. The code works perfectly fine on 3 computers but didn't work on other 2 computers. And its giving Error 32809 on other 2.

    What could be the problem? The error comes up at the following red lines in the VBA Code.

    UserForm1.Caption = "BatchNo : " & ThisWorkbook.Worksheets("BatchCounting").Cells(6, "B").Value
       UserForm1.Label1.Visible = False
       UserForm1.TextBox1.Visible = False
       UserForm1.CommandButton1.Visible = False
       UserForm1.CmdSAVE.Visible = True
       UserForm1.CmdABANDON.Visible = True
       With UserForm1
       .Label2.Left = 12
       .Label2.Top = 30
       .txtbatch.Left = 102
       .txtbatch.Top = 30
       .txtbatch.Value = ThisWorkbook.Worksheets("BatchCounting").Cells(6, "B").Value  
     .txtbatch.Locked = True
       
       
       .Label3.Left = 12
       .Label3.Top = 60
       .TxtPages.Left = 102
       .TxtPages.Top = 60
       .TxtPages.Value = ThisWorkbook.Worksheets("BatchCounting").Cells(6, "C").Value 
      .TxtPages.Locked = True
      
       
       .Label4.Left = 12
       .Label4.Top = 90
       .TxtCases.Left = 102
       .TxtCases.Top = 90
       .TxtCases.Value = ThisWorkbook.Worksheets("BatchCounting").Cells(6, "D").Value   
    .TxtCases.Locked = True
       
       .CmdSAVE.Left = 18
       .CmdSAVE.Top = 150
       .CmdABANDON.Left = 144
       .CmdABANDON.Top = 150
       End With

  2. #2
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    22,009

    Re: Run-time Error 32809: Application-defined Or Object-defined Error

    Every single instance of that error I have seen recently has related to this: http://excelmatters.com/2014/12/10/o...ivex-controls/
    Everyone who confuses correlation and causation ends up dead.

+ 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. excel macro run time error '1004'- Application defined or object defined error
    By kmadan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-16-2014, 09:51 AM
  2. Replies: 1
    Last Post: 03-12-2014, 12:42 PM
  3. [SOLVED] Error " Run-time error '1004': application defined or object defined error
    By lengwer in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-11-2013, 07:26 AM
  4. [SOLVED] Run-time Error 32809: Application-defined or object-defined error
    By Taislin in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-28-2013, 04:15 PM
  5. [SOLVED] run-time error '1004' application-defined or object-defined error - Excel 2007
    By kaurka in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-06-2012, 02:46 AM

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