+ Reply to Thread
Results 1 to 2 of 2

Error Message: Compile Error: Method or data Member not found

  1. #1
    Registered User
    Join Date
    01-19-2017
    Location
    Manila, Philippines
    MS-Off Ver
    2010
    Posts
    6

    Error Message: Compile Error: Method or data Member not found

    Hi,

    I currently creating a VBA in excel and one of the forms I am using has 2 option button (for Yes and No option) to determine which form to load once i click an image (named Next) however I am getting the error "Compile Error: Method or data Member not found". Below is the code i used:

    Private Sub Image5_Click() ---> image named "NEXT" to move to the next form
    Dim Selection As Integer, result As String
    Selection = Sheet1.Range("E2:E3").Value

    If Me.OptionButton1 = True Then BT9_10.Activate ----> "Yes" option button
    If Me.OptionButton2 = True Then BT4_Offers.Activate ----> "No" option button
    End Sub

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436

    Re: Error Message: Compile Error: Method or data Member not found

    If BT9_10 is a userform then you need to use the show method. Activate is any event
    Cheers
    Andy
    www.andypope.info

+ 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] Compile error: Method or data member not Found
    By jasond1992 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-25-2015, 02:29 AM
  2. [SOLVED] Compile error: Method or data member not found
    By aliciaward1001 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-26-2015, 04:11 PM
  3. Compile error:Method or data member not found
    By vshukla in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-16-2015, 11:44 AM
  4. Compile error method or data member not found
    By sureshpunna in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-14-2014, 09:00 AM
  5. Compile Error Method or data member not found
    By ixelister in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-23-2014, 03:39 PM
  6. [SOLVED] Compile error: Method or data member not found.
    By ndtsteve in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-10-2012, 11:31 AM
  7. Compile Error Method or data member not found
    By ExcelMonkey in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-04-2005, 06:05 PM

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