+ Reply to Thread
Results 1 to 4 of 4

Run-Time error '424': Object Required??????

  1. #1
    Forum Contributor
    Join Date
    12-11-2009
    Location
    Toronto
    MS-Off Ver
    Excel 2010
    Posts
    517

    Run-Time error '424': Object Required??????

    Hello all, not sure why i am getting this error. I tried everything to fix the problem but this error msg doesnt want to go. Can some please look at this for me. I get error on the CommandButton1.Top= .Top line. It used to work fine before and now i just get this error msg. Im using Excel 2010
    This is the code:

    Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
    With Cells(Windows(1).ScrollRow, Windows(1).ScrollColumn)
    CommandButton1.Top = .Top
    CommandButton1.Left = .Left + 740

    End With
    End Sub

    Thanks

  2. #2
    Registered User
    Join Date
    06-17-2009
    Location
    Canada
    MS-Off Ver
    Office 2010
    Posts
    84

    Re: Run-Time error '424': Object Required??????

    Sounds like the error that was caused by Microsoft update. Command buttons for me had stopped working.
    http://www.excelforum.com/excel-prog...ml#post3925418

  3. #3
    Forum Contributor
    Join Date
    12-11-2009
    Location
    Toronto
    MS-Off Ver
    Excel 2010
    Posts
    517

    Re: Run-Time error '424': Object Required??????

    tried this option and still did not work

  4. #4
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,059

    Re: Run-Time error '424': Object Required??????

    Can you maybe provide the workbook?
    Please help by:

    Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
    Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know

    There are 10 kinds of people in this world... those who understand binary, and those who don't.

+ 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. [SOLVED] Simple Calendar pop up macro --> error Run-time error '424': Object required
    By am_hawk in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-11-2013, 10:38 AM
  2. Run-Time error 424 - Object required
    By Mr_Knows_Nothing in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-04-2012, 01:19 PM
  3. Run Time Error 424:Object Required
    By ewalton87 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-19-2011, 09:33 PM
  4. Run-time error '424': Object Required
    By ElmerFuddy in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-04-2009, 05:30 PM
  5. Run-time error '424': Object required
    By ez_cali in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 05-21-2005, 03:52 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