+ Reply to Thread
Results 1 to 3 of 3

Error 424 Object required

  1. #1
    Registered User
    Join Date
    04-25-2006
    Posts
    25

    Error 424 Object required

    Hi there,
    I have a (multi)page form containing 2 frames, each with some text- and comboxes. After the values of the boxes been written to the sheet, the values of the boxes are cleared with the below 'cleanup' proc. However when running the code I get an Error 424 on the line Set oCtrl1 = vArray(iCount).

    What I am doing wrong ?



    Please Login or Register  to view this content.
    Thks for your help - Eric

  2. #2
    Forum Contributor SOS's Avatar
    Join Date
    01-26-2004
    Location
    Glasgow, Scotland
    MS-Off Ver
    Excel 2003
    Posts
    327
    Eric,

    Try changing the code to the following - at least it worked for me. That is assuming that your controls are still called "Combobox1", "Combobo2", "Textbox1, "Textbox2" etc.

    Your original code appeared to be calling the text or values within the controls as opposed to the controls themselves.

    Please Login or Register  to view this content.
    Hope this helps

    Seamus

  3. #3
    Registered User
    Join Date
    04-25-2006
    Posts
    25
    Hi Seamus,

    Thanks for your quick reply and yes, indeed, your code works fine.
    Actually, your reply prompted me to look very carefully at my original code.
    Seems that I made some typo errors in my original code: instead of "Combobox" and "Textbox" I should have typed "ComboBox' and "TextBox",
    capitalizing the b in to B (as it should be) did the trick and the original code now works.
    Thanks for 'cleaninp up' my mind on this. Much appreciated !
    Eric

+ 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