Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    Feb 2001
    Location
    Glasgow, Scotland
    Posts
    46
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Userform Maximum No? (97/SR2)

    Is there a maximum number of Userforms that can be used in an excel spreadsheet. My sheet has started crashing after I created 38 userforms. I have had some problems with the code associated with these, however these have been solved by increasing the number of modules and spliting the code between the modules.

    Cheers
    Angus

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Userform Maximum No? (97/SR2)

    I don't know of any maximum. But I strongly suspect your code needs cleaning. Try Rob Bovey's code cleaner from the Excel MVP page below my signature.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

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