Bonjour,
J'ai un pb sur Excel XP, avec une feuille sur laquelle j'ai une combobox comportant une liste d'environ 137 lignes. Au bout d'un moment, si je descend ou monte dans la liste, erreur d'excel avec fermeture obligatoire . Il semblerait que le module incriminé soit le fichier fm20.dll qui gère ces objets, en cherchant j'ai pu télécharger une mise à jour de ce fichier, mais le pb persiste sous la forme d'un blocage avec affichage d'un message d'erreur : mémoire insuffisante pour afficher en entier.  
SI quelqu'un a des infos (notamment sur la longueur maxi d'une liste), merci d'avance.

peux tu nous montrer comment tu as insérer les 137 lignes dans ta combobox voir nous donner ton code pour que l'on teste de notre coté ?

as tu lu ça chez microsoft ?
http://support.microsoft.com/kb/241245/EN-US/
This article was previously published under Q241245
SYMPTOMS
A Visual Basic application is deployed on a target machine. When attempting to run the application on a target machine that does not have Microsoft Office 97 or later installed, the following error is generated:  
Error 7 - Out of Memory
No loss of memory is monitored, and the system appears stable. The application executes properly if Microsoft Office 97 is installed on the target machine.  
CAUSE
The problem is that FM20.DLL file is used by the project. FM20.DLL file is not a redistributable component and is intended for VBA use only. FM20.DLL is known to have many problems when used with Visual Basic and other developer products. Its use is neither recommended nor supported in any Visual Studio product.  
RESOLUTION
The best resolution is to remove FM20.DLL from the project.
 
An alternative is to deploy the application only to machines with Microsoft Office 97 or later installed. To do this, remove the reference to FM20.DLL from the PDW or Setup Wizard file list. This prevents the install wizard from installing it. Note in your product documentation that installing the appropriate version of Microsoft Office on the target machine is a pre-requisite to installing your application.  
STATUS
This behavior is by design.  
REFERENCES
For additional information about using FM20.DLL, please click the article number below to view the article in the Microsoft Knowledge Base:  
224305 (http://support.microsoft.com/kb/224305/EN-US/) INFO: Usage and Redistribution of FM20.DLL  
To see what components are redistributable, read the "Redist.TXT" file that ships with Visual Basic. This file is installed to your hard drive or it can be found in the "\Common\Redist\" folder on the Visual Basic 6.0 CD-ROM or in the "\vb\" folder of the Visual Basic 5.0 CD-ROM.