+ Reply to Thread
Results 1 to 5 of 5

Object required error..

  1. #1
    Registered User
    Join Date
    04-24-2012
    Location
    Chennai
    MS-Off Ver
    Excel 2007
    Posts
    2

    Object required error..

    Hi,

    While accessing the control values options, object required error is existing. May i know the reason for this...? Please find the code below.
    copy to clipboard
    Please Login or Register  to view this content.
    Last edited by davesexcel; 04-25-2012 at 06:26 AM.
    Regards,
    Deva

  2. #2
    Forum Guru davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    XL 2003,2010,2013
    Posts
    7,545

    Re: Object required error..

    hi Deva,
    Please use code tags when supplying VBA code.

  3. #3
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,204

    Re: Object required error..

    What's Testing_Click? If you haven't a control called Testing then you will get the error
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  4. #4
    Registered User
    Join Date
    04-24-2012
    Location
    Chennai
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Object required error..

    Hi RoyUK,

    Testing is the button name. In the controls am able to access only the button_click method . Other than that, am not able to access the button properties like, button.enabled = true etc.. If i used this kind of statement means, the object required error is occuring. May i know the reason for this.?

  5. #5
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,204

    Re: Object required error..

    is it a button from the Forms controls? If it is then they don't have those properties

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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