Consulting

Results 1 to 2 of 2

Thread: UserForm & Macros from Office 2003 to Office 2007 causes errors. Any ideas?

  1. #1
    VBAX Newbie
    Joined
    Dec 2009
    Posts
    1
    Location

    UserForm & Macros from Office 2003 to Office 2007 causes errors. Any ideas?

    I have an Excel program which I designed in Office 2003. This program worked perfectly for a few years in Office 2003, but I am now trying to run it with Excel 2007 and have run into some problems.

    It has a UserForm object named "UserForm1". In this UserForm, I have a Frame which I named Spreadsheet1.

    Every time I try to run the program, the debugger throws the following error in UserForm1's code:

    "Run-time error '438': Object doesn't support this property or method"

    Me.Spreadsheet1.Cells.Clear


    I also get the same error when I just try to run the following from a different Module:

    UserForm1.Show


    ANY IDEAS would be GREATLY appreciated! I am completely stumped!

  2. #2
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    What makes you think that a frame has cells?
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •