Bonjour,
Alors je dirai :
<span style="color:#008000">'*************************************************************************</span>
<br /><span style="color:#008000">'* Reformatage de la feuille en adaptant les controles présents</span>
<br /><span style="color:#008000">'*************************************************************************</span>
<br /><span style="color:#0000FF">Private</span> <span style="color:#0000FF">Sub</span> Form_Resize()
<br /><span style="color:#0000FF">Dim</span> ctl <span style="color:#0000FF">As</span> Control
<br />
<br /> <span style="color:#008000">'-- On vérifie que le l'état visuel de la Feuille n'est pas sur minimale</span>
<br /> <span style="color:#008000">'-- Si c'est le cas on sort de la procédure</span>
<br /> <span style="color:#0000FF">If</span> (<span style="color:#0000FF">Me</span>.WindowState = 1) <span style="color:#0000FF">Then</span> <span style="color:#0000FF">Exit</span> <span style="color:#0000FF">Sub</span>
<br /> <span style="color:#008000">'-- Pour chaque controle</span>
<br /> <span style="color:#0000FF">For</span> <span style="color:#0000FF">Each</span> ctl <span style="color:#0000FF">In</span> <span style="color:#0000FF">Me</span>.Controls
<br /> <span style="color:#008000">'-- On vérifie le type de controle</span>
<br /> <span style="color:#0000FF">If</span> <span style="color:#0000FF">TypeOf</span> ctl <span style="color:#0000FF">Is</span> ComboBox <span style="color:#0000FF">Then</span>
<br /> <span style="color:#008000">'-- Les comboboxes ont leur Propriété Height en lecture seule</span>
<br /> <span style="color:#008000">'-- On modifie les propriétées de Largeur, de position</span>
<br /> ctl.Move ctl.Left * <span style="color:#0000FF">Me</span>.Width / Lng, ctl.Top * <span style="color:#0000FF">Me</span>.Height / lLar, ctl.Width * <span style="color:#0000FF">Me</span>.Width / lLng
<br /> <span style="color:#0000FF">Else</span>
<br /> <span style="color:#008000">'-- On modifie les propriétées de Largeur, de hauteur, de position</span>
<br /> <span style="color:#0000FF">If</span> ExistProperty(ctl, "<span style="color:#8B0000">Width</span>") <span style="color:#0000FF">And</span> ExistProperty(ctl, "<span style="color:#8B0000">Height</span>") <span style="color:#0000FF">Then</span>
<br /> ctl.Move ctl.Left * <span style="color:#0000FF">Me</span>.Width / lLng, ctl.Top * <span style="color:#0000FF">Me</span>.Height / lLar, _
<br /> ctl.Width * <span style="color:#0000FF">Me</span>.Width / lLng, ctl.Height * <span style="color:#0000FF">Me</span>.Height / lLar
<br /> <span style="color:#0000FF">End</span> <span style="color:#0000FF">If</span>
<br /> <span style="color:#0000FF">End</span> <span style="color:#0000FF">If</span>
<br /> <span style="color:#0000FF">Next</span>
<br /> <span style="color:#008000">'-- On redéfini les variables</span>
<br /> lLng = <span style="color:#0000FF">Me</span>.Width
<br /> lLar = <span style="color:#0000FF">Me</span>.Height
<br />
<br /><span style="color:#0000FF">End</span> <span style="color:#0000FF">Sub</span>
<br />
<br /><span style="color:#008000">'*************************************************************************</span>
<br /><span style="color:#008000">'* On test si la propriété du controle existe</span>
<br /><span style="color:#008000">'*************************************************************************</span>
<br /><span style="color:#0000FF">Public</span> <span style="color:#0000FF">Function</span> ExistProperty(Obj <span style="color:#0000FF">As</span> <span style="color:#0000FF">Object</span>, <span style="color:#0000FF">ByVal</span> PropertyName <span style="color:#0000FF">As</span> <span style="color:#0000FF">String</span>) <span style="color:#0000FF">As</span> <span style="color:#0000FF">Boolean</span>
<br />
<br /> <span style="color:#008000">'-- Fonction qui test les différentes propriétés a savoir si elle existe ou pas.</span>
<br /> <span style="color:#0000FF">On</span> <span style="color:#0000FF">Error</span> <span style="color:#0000FF">Resume</span> <span style="color:#0000FF">Next</span>
<br /> CallByName Obj, PropertyName, VbGet
<br /> ExistProperty = (Err.Number = 0)
<br /> Err.Clear
<br />
<br /><span style="color:#0000FF">End</span> <span style="color:#0000FF">Function</span>
<br /><br />
<!-- Code colorisé via
http://tools.codes-sources.com/colorizeCode.aspx -->
S.L.B.
-- Le règlement tu liras -- Des recherches tu feras -- Le style SMS tu banniras --
-- De la validation pertinente tu feras -- Du respect tu auras -- <