Results 1 to 9 of 9

Showing Forms

Threaded View

  1. #1
    Forum Contributor
    Join Date
    03-30-2010
    Location
    Manchester England
    MS-Off Ver
    Excel 2010
    Posts
    992

    Showing Forms

    Dear Forum Members
    RomperStomper has just helped me by solving a problem "RemoveDuplicates in VBA" which seemed to revolve round a parameter array used in the RemoveDuplicate coding.
    On the same workbook I now have a problem where I cannot show a userform because of the following error message
    "Could not set list property. Invalid property array index".
    The code involved is
    Private Sub UserForm_Initialize()
    With EntryForm
     .ListBox1.List = Sheets("ALL_UNCHECKED").Range("A11").CurrentRegion.Value
    '.ListBox1.List = Sheets("ALL_UNCHECKED").Range("A11:J16")
    .TextBox12.Value = Format(Now, "dd/mm/yyyy")
    .TextBox13.Value = Sheets("UTILITIES").Range("A10").Value
    End With
    flag = 0
    
    End Sub
    Neither the third line or the rem'd line work, and I am surprised I have used very similar code before. Is it possible that my two problems are connected?
    I have attached the full workbook.
    OpenForm just enables secondform and it is the button Enter Orders which starts the problem.
    The sub userForm_initialise() is in the code of EntryForm
    Attached Files Attached Files
    Last edited by j_Southern; 11-29-2011 at 05:24 AM.

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