Results 1 to 9 of 9

error messages from check box code...

Threaded View

lottesfog error messages from check box... 09-24-2007, 10:54 PM
smart89 modify code like this If... 09-24-2007, 11:36 PM
BigBas The code checkbox2.checked... 09-24-2007, 11:46 PM
lottesfog Thanks for the suggestions. ... 09-24-2007, 11:55 PM
smart89 be sure of the name of check... 09-25-2007, 12:02 AM
BigBas Can you post the full code? 09-25-2007, 12:02 AM
  1. #1
    Registered User
    Join Date
    08-27-2007
    Posts
    48

    error messages from check box code...

    Hi,
    I am trying to use a check box in an excel sheet. However, this line of code:

    If CheckBox2.Checked = True Then
    produces the following error: Runtime error 424 - object required.
    Why does Excel not recognise the check box as an object?

    If I change the code to:
    If ActiveSheet.Checkbox2.Checked = True Then
        MsgBox "true"
    End if

    The following error is returned: "Runtime error 438 - Object doesn't support thid property or method"

    - what's going on? The correct sheet is selected, and the "Microsoft DAO 3.6 object library" is selected under references...

    Lotte
    Last edited by VBA Noob; 10-24-2007 at 03:24 AM.

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1