+ Reply to Thread
Results 1 to 7 of 7

[SOLVED] Help "438 - Object doesn't support this property or method"

  1. 09-01-2011, 04:43 AM #1
    Jonthurston7 is offline
    Registered User
    Join Date
    09-01-2011
    Location
    Southampton, England
    MS-Off Ver
    Excel 2003
    Posts
    4

    [SOLVED] Help "438 - Object doesn't support this property or method"

    I'm creating a form in Excel 2003 using VBA, and am receiving the above error message but can't see why.

    Basically I have created several error messages which pop up when the Submit To Log Button is clicked, to ensure fields on the form are completed, however I keep getting the above error around the InvestmentType, Premium or Sum Assured control box.

    Anyone know why I am getting this error?
    Attached Files Attached Files
    Last edited by Jonthurston7; 09-01-2011 at 07:09 AM.
    Reply With QuoteRegister To Reply
  2. 09-01-2011, 04:47 AM #2
    Andy Pope is offline
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,482

    Re: Help "438 - Object doesn't support this property or method"

    You are looping through the controls in the frame and not all of them have the caption property.

    Please Login or Register  to view this content.
    you need to check the type of control before using the caption or text property.
    Cheers
    Andy
    www.andypope.info
    Reply With QuoteRegister To Reply
  3. 09-01-2011, 04:54 AM #3
    Jonthurston7 is offline
    Registered User
    Join Date
    09-01-2011
    Location
    Southampton, England
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Help "438 - Object doesn't support this property or method"

    If I removed the "Amount" boxes would that solve the problem?
    Reply With QuoteRegister To Reply
  4. 09-01-2011, 04:58 AM #4
    Bob Phillips is offline
    Forum Expert Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,284

    Re: Help "438 - Object doesn't support this property or method" 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  5. 09-01-2011, 05:06 AM #5
    Andy Pope is offline
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,482

    Re: Help "438 - Object doesn't support this property or method" 

    Please Login or Register  to view this content.
    Although I'm not sure why you are looping and counting Investmenttypes as only 1 of the option buttons can ever be selected.
    Reply With QuoteRegister To Reply
  6. 09-01-2011, 05:48 AM #6
    Jonthurston7 is offline
    Registered User
    Join Date
    09-01-2011
    Location
    Southampton, England
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Help "438 - Object doesn't support this property or method"

    Thanks for your help guys, really appreciated.

    Will no doubt have a few more vba queries soon so may speak to you again.

    Thanks
    Reply With QuoteRegister To Reply
  7. 09-01-2011, 06:13 AM #7
    Bob Phillips is offline
    Forum Expert Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,284

    Re: Help "438 - Object doesn't support this property or method"

    Quote Originally Posted by Andy Pope View Post
    Although I'm not sure why you are looping and counting Investmenttypes as only 1 of the option buttons can ever be selected.
    My point exactly
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1