Results 1 to 9 of 9

Compile error Method or data member not found

Threaded View

  1. #5
    Registered User
    Join Date
    01-12-2014
    Location
    Plano, Tx
    MS-Off Ver
    365
    Posts
    57

    Re: Compile error Method or data member not found

    Ok, I figured out my error on the text box label issue, but now I'm having an issue with the 2nd combo box. First combo Box works fine, but no drop down list is showing up on the 2nd combo box. I am attaching the sheet. You can go through a dummy trial of adding a complaint and see how it happens.
    Here is the code:
    Private Sub UserForm_Initialize() 'List of 35 stores on the "Stores" worksheet
     For i = 1 To 35
     ComboBox_Country.AddItem Sheets("Stores").Cells(i, 1)
     Next
     End Sub
     Private Sub OptionButton4_Click()
     End Sub
     Private Sub UserForm1_Initialize() 'List of Type of Complaints on the "Type" worksheet
     For i = 1 To 6
     ComboBox_Country1.AddItem Sheets("Type").Cells(i, 1)
     Next
     End Sub
    Attached Files Attached Files
    Last edited by 6StringJazzer; 08-30-2016 at 08:43 AM. Reason: Adding missing bracket to fix code tag

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. [SOLVED] 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