Results 1 to 6 of 6

Compile error method or data member not found

Threaded View

  1. #1
    Registered User
    Join Date
    11-26-2012
    Location
    hyderabad
    MS-Off Ver
    Excel 2010
    Posts
    43

    Compile error method or data member not found

    Hi,

    I'm using the below code dependent combo box but when i opens file getting error msg "compile error method or data member not found".

    Please help. Thank you in advance.


    Private Sub ComboBox1_Change()
    If Me.ComboBox1.Value = ALL_INDIA Then
    Me.ComboBox2.Value = ""
    Else
    Me.ComboBox2.ListFillRange = Me.ComboBox1.Value
    End If
    End Sub
    
    Private Sub ComboBox2_Change()
    Me.ComboBox3.Value = ""
    Me.ComboBox3.ListFillRange = Me.ComboBox1.Value & Me.ComboBox2.Value
    End Sub
    
    Private Sub ComboBox3_Change()
    Me.ComboBox4.Value = ""
    Me.ComboBox4.ListFillRange = Me.ComboBox3.Value
    End Sub
    Last edited by sureshpunna; 08-14-2014 at 12:22 AM. Reason: spelling mistake

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. 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
  2. [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
  3. Compile Error: Method of data member not found (VBA)
    By vbatech in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 03-14-2012, 05:37 PM
  4. Compile Error:Method or Data Member Not Found
    By loknath in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-29-2012, 04:03 AM
  5. 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