+ Reply to Thread
Results 1 to 2 of 2

Run-Time Error '438' - Object doesn't support this property or method

Hybrid View

  1. #1
    Registered User
    Join Date
    04-25-2011
    Location
    chennai, India
    MS-Off Ver
    Excel 2007
    Posts
    2

    Thumbs up Run-Time Error '438' - Object doesn't support this property or method

    Dear Experts,

    I am bit confused on this as I am new with the VBA programming. Recently I converted a file from excel03 to 07 and the Combobox (Macro) is not working in 2007. Then I went for a form with new ComboBox using ActiveX Control. It is working fine in some machines and nt working in some other machine once it is successfully closed and try to reopen again.

    When I try to run the Macro, it is showing as "Run-Time Error '438' - Object doesn't support this property or method"

    Please help on this.

    Thanks in advance!!!

    Private Sub ComboBox1_Change()
    Cells(12, 6) = "Graphs For -" & ComboBox1.Value
    Call Module1.update_graphs(ComboBox1.Value)
    End Sub
    Last edited by rajibyumnam; 04-27-2011 at 12:21 AM. Reason: Get solved...The problem was that the ActiveX Control was disable in my Machine.. Thanx to all for ur reply

  2. #2
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,342

    Re: Run-Time Error '438' - Object doesn't support this property or method

    Hi rajibyumnam,
    Try .....
    Private Sub ComboBox1_Change()
    Cells(12, 6) = "Graphs For -" & ComboBox1.Value
    Call update_graphs(ComboBox1.Value)
    End Sub
    where "update_graphs(ComboBox1.Value)" is a subroutine
    If the solution helped please donate to RSPCA

    Site worth visiting: Rabbitohs

+ 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1