Consulting

Results 1 to 11 of 11

Thread: Solved: Date picker userform - the size is changed

  1. #1
    VBAX Regular
    Joined
    Feb 2009
    Posts
    55
    Location

    Solved: Date picker userform - the size is changed

    Hi

    I am using a date picker userform, after I set it up to my desired size and save it, exiting excel and re starting it, the displayed userform size is changed.

    Is there a way to LOCK the size / location of a userform ?

    thanks !!!

  2. #2
    Knowledge Base Approver VBAX Master Oorang's Avatar
    Joined
    Jan 2007
    Posts
    1,135
    Location
    If you are setting your size via the properties, then they should be saved. How are you actually setting it?
    Cordially,
    Aaron



    Keep Our Board Clean!
    • Please Mark your thread "Solved" if you get an acceptable response (under thread tools).
    • Enclose your code in VBA tags then it will be formatted as per the VBIDE to improve readability.

  3. #3
    VBAX Regular
    Joined
    Feb 2009
    Posts
    55
    Location
    I just drag the edges to the size I wish.

    save

    exit excel


    what do I do wrong ?


    thanks

  4. #4
    Knowledge Base Approver VBAX Master Oorang's Avatar
    Joined
    Jan 2007
    Posts
    1,135
    Location
    Are you dragging the edges in design view or in display view?
    Cordially,
    Aaron



    Keep Our Board Clean!
    • Please Mark your thread "Solved" if you get an acceptable response (under thread tools).
    • Enclose your code in VBA tags then it will be formatted as per the VBIDE to improve readability.

  5. #5
    Moderator VBAX Wizard lucas's Avatar
    Joined
    Jun 2004
    Location
    Tulsa, Oklahoma
    Posts
    7,323
    Location
    If you plan on using the calendar on more than one computer you should read this thread:

    http://www.vbaexpress.com/forum/showthread.php?t=10914
    Steve
    "Nearly all men can stand adversity, but if you want to test a man's character, give him power."
    -Abraham Lincoln

  6. #6
    Knowledge Base Approver VBAX Master Oorang's Avatar
    Joined
    Jan 2007
    Posts
    1,135
    Location
    Hey Lucas, do you know what "unreliabilities" in the Calander Control Ken was referring to?
    Cordially,
    Aaron



    Keep Our Board Clean!
    • Please Mark your thread "Solved" if you get an acceptable response (under thread tools).
    • Enclose your code in VBA tags then it will be formatted as per the VBIDE to improve readability.

  7. #7
    Moderator VBAX Wizard lucas's Avatar
    Joined
    Jun 2004
    Location
    Tulsa, Oklahoma
    Posts
    7,323
    Location
    Hi Aaron, principally, the library is not present on all machines, even with similar installations........see this from post #11 of the linked thread.

    it was working fine on the laptop i made the workbook on, but when i opened it up on another, almost identical machine it would throw a "can't find object or library" error.
    If you want to use the native calendar control on a file that will be used on many machines you will run into this problem quite often. The only thing you can do is make sure the calendar control is installed on every machine it gets used on........an overwhelming caveat in most cases...
    Steve
    "Nearly all men can stand adversity, but if you want to test a man's character, give him power."
    -Abraham Lincoln

  8. #8
    Knowledge Base Approver VBAX Master Oorang's Avatar
    Joined
    Jan 2007
    Posts
    1,135
    Location
    Excellent, thanks lucus.
    Cordially,
    Aaron



    Keep Our Board Clean!
    • Please Mark your thread "Solved" if you get an acceptable response (under thread tools).
    • Enclose your code in VBA tags then it will be formatted as per the VBIDE to improve readability.

  9. #9
    VBAX Regular
    Joined
    Feb 2009
    Posts
    55
    Location
    I am pretty new to VBA.

    Did not notice the Design mode.

    Does it make any difference ?

    thanks !

  10. #10
    Knowledge Base Approver VBAX Master Oorang's Avatar
    Joined
    Jan 2007
    Posts
    1,135
    Location
    It's the difference between it getting saved or not
    Cordially,
    Aaron



    Keep Our Board Clean!
    • Please Mark your thread "Solved" if you get an acceptable response (under thread tools).
    • Enclose your code in VBA tags then it will be formatted as per the VBIDE to improve readability.

  11. #11
    VBAX Regular
    Joined
    Feb 2009
    Posts
    55
    Location
    cool.

    thanks a lot.

Posting Permissions

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