+ Reply to Thread
Results 1 to 3 of 3

Redimensionnement automatique des controls dans un userform

  1. #1
    Registered User
    Join Date
    08-06-2014
    Location
    quebec
    MS-Off Ver
    2010
    Posts
    5

    Redimensionnement automatique des controls dans un userform

    Bonjour,
    J'ai un userform qui s'ouvre avec un fichier excel. Ce Userform a été développé sur un écran avec une certaine résolution et lorsque je l'ouvre sur une autre machine ayant un écran différent, je ne peux pas voir toute l'interface et les contrôles. J'ai téléchargé un exemple de projet qui permet d'ajouter les boutons agrandir et réduire dans le Caption de la Userform et le code fonctionne très bien. Cependant, lorsque j'applique le code à mon projet, j'obtiens une erreur de compilation: Incompatibilité de type.

    Voici mon code: (l'erreur est sur la ligne: handle = FindWindow(vbNullString, uf.Caption )

    Please Login or Register  to view this content.
    Quelqu'un peut m'aider avec ça?

    Merci!
    Last edited by trevsiob; 02-04-2021 at 12:40 PM.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: Redimensionnement automatique des controls dans un userform

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however you need to include code tags around your code.

    Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

    Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

    (Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    08-06-2014
    Location
    quebec
    MS-Off Ver
    2010
    Posts
    5

    Re: Redimensionnement automatique des controls dans un userform

    (Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)[/QUOTE]

    Thanks for letting me know and sorry about that. I think it's all ok now!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Userform Login on userform and disabling/enabling userforms controls
    By waimea in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-23-2019, 10:37 AM
  2. [SOLVED] calculation automatique of names
    By SBAY3I in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-03-2018, 12:11 PM
  3. [SOLVED] Automatique exchange of data
    By Galliass in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 06-08-2017, 07:51 AM
  4. Adding controls to Userform from another Userform
    By AdiK in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 02-09-2017, 11:49 AM
  5. [SOLVED] Userform Controls shortcut - close userform by escape key
    By ag273n in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-05-2014, 06:23 PM
  6. Défilement automatique de données
    By GuyC in forum Non English Excel
    Replies: 31
    Last Post: 01-28-2012, 07:32 PM
  7. Automatique Shape
    By Modeste in forum Excel General
    Replies: 1
    Last Post: 10-18-2005, 12:05 PM

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