Glaswegian
08-08-2012, 07:09 AM
Hi
Is there any limit on the number of userforms that Excel 2010 can work with?
I've been having issues with a workbook that I wrote before we switched to Excel 2010 and a developer team are now looking at a re-write. One of their suggestions is using userforms, which sounds fine except, depending on their proposed solution, there could be several hundred userforms in the final version.
I have some ideas to reduce this but I'm curious if Excel has any limits/issues in respect of userforms. Can't find anything definitive on the web.
Thanks.
Is there any limit on the number of userforms that Excel 2010 can work with?
I've been having issues with a workbook that I wrote before we switched to Excel 2010 and a developer team are now looking at a re-write. One of their suggestions is using userforms, which sounds fine except, depending on their proposed solution, there could be several hundred userforms in the final version.
I have some ideas to reduce this but I'm curious if Excel has any limits/issues in respect of userforms. Can't find anything definitive on the web.
Thanks.