+ Reply to Thread
Results 1 to 17 of 17

UserForm changing size from one computer to another

  1. #1
    Forum Contributor
    Join Date
    09-10-2008
    Location
    Phoenix, AZ
    MS-Off Ver
    Office 365
    Posts
    748

    UserForm changing size from one computer to another

    Hello Excel Geniuses',

    I have a simple set of Text Boxes and when the User select the Clear button I want the curser to go back to Text Box 1, Any Samples?

    Please Login or Register  to view this content.
    Best Regards,

    John
    Last edited by JJFletcher; 10-10-2015 at 10:59 AM.

  2. #2
    Forum Expert Greg M's Avatar
    Join Date
    08-16-2007
    Location
    Dublin. Ireland
    MS-Off Ver
    Office 2013
    Posts
    3,483

    Re: Small Assistance If you Please

    Hi there,

    The following addition should work if your TextBoxes are located on a UserForm (i.e. not on a WorkSheet):

    Please Login or Register  to view this content.
    Hope this helps - please let me know how you get on.

    Regards,

    Greg M


    P. S. Use TextBox1.Activate if the TextBoxes are located on a worksheet
    Last edited by Greg M; 10-10-2015 at 10:35 AM. Reason: P. S. added

  3. #3
    Forum Contributor
    Join Date
    09-10-2008
    Location
    Phoenix, AZ
    MS-Off Ver
    Office 365
    Posts
    748

    Re: Small Assistance If you Please

    That worked perfectly - Great Solution...

    Yes this is for a UserForm... On that note - The UserForm that I am using is attached here... It changes it's size from one computer to the next.. Any solutions for this effect?

    ClassificationsV2.xlsm

    Thanks so much!

  4. #4
    Forum Expert Greg M's Avatar
    Join Date
    08-16-2007
    Location
    Dublin. Ireland
    MS-Off Ver
    Office 2013
    Posts
    3,483

    Re: Small Assistance If you Please

    Hi again,

    Many thanks for your feedback - glad I was able to help.

    As regards the UserForm changing size from one computer to another, the only thing that springs to mind is that the screen resolution on all of those computers might not be the same - sorry I can't think of anything else at the moment.

    Best regards,

    Greg M

  5. #5
    Forum Contributor
    Join Date
    09-10-2008
    Location
    Phoenix, AZ
    MS-Off Ver
    Office 365
    Posts
    748

    Re: Small Assistance If you Please

    Thanks for your feedback... Hopefully someone has a solution

  6. #6
    Forum Guru
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,032

    Re: UserForm changing size from one computer to another

    Not much better than the above code
    But darn useful if you have more textboxes.

    Please Login or Register  to view this content.

    This will clear every single textbox

    Please Login or Register  to view this content.
    Last edited by mehmetcik; 10-10-2015 at 11:46 AM.
    Please Avoid Joining My List Of Blocked Users by:

    Saying Please and Thank you.

    Making requests not demands.

    Checking back on your post. I will not edit any post after 4 days.

    Marking threads as closed once your issue is resolved. How? The tools at the top

    Any reputation (*) points appreciated. None of us gets paid here.

    If you found someone's input useful, please take a second to click the * at the bottom left to let them know

  7. #7
    Forum Contributor
    Join Date
    09-10-2008
    Location
    Phoenix, AZ
    MS-Off Ver
    Office 365
    Posts
    748

    Re: UserForm changing size from one computer to another

    Thanks mehmetcik,

    I tried the code and works great... any thoughts on the Computer to Computer changes to the Userform.. Would like it to stick at one size fits all

    Best Regards,

    John

  8. #8
    Forum Expert Greg M's Avatar
    Join Date
    08-16-2007
    Location
    Dublin. Ireland
    MS-Off Ver
    Office 2013
    Posts
    3,483

    Re: UserForm changing size from one computer to another

    Hi again John,

    Many thanks for the Reputation increase - much appreciated!

    Best regards,

    Greg M

  9. #9
    Forum Contributor
    Join Date
    09-10-2008
    Location
    Phoenix, AZ
    MS-Off Ver
    Office 365
    Posts
    748

    Re: UserForm changing size from one computer to another

    My pleasure - and thanks again

    Best Regards,

    John

  10. #10
    Forum Guru
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,032

    Re: UserForm changing size from one computer to another

    Is the userform size change affecting the layout of the controls?

  11. #11
    Forum Contributor
    Join Date
    09-10-2008
    Location
    Phoenix, AZ
    MS-Off Ver
    Office 365
    Posts
    748

    Re: UserForm changing size from one computer to another

    Yes - the computer at my work the whole UserForm is smaller and I have to move stuff around

  12. #12
    Forum Contributor
    Join Date
    09-10-2008
    Location
    Phoenix, AZ
    MS-Off Ver
    Office 365
    Posts
    748

    Re: UserForm changing size from one computer to another

    mehmetcik,

    Thought I would ask you if you know of a solution for the All in one fits all UserForm issue.

    John

  13. #13
    Forum Contributor
    Join Date
    09-10-2008
    Location
    Phoenix, AZ
    MS-Off Ver
    Office 365
    Posts
    748

    Re: UserForm changing size from one computer to another

    Thanks for all the help

  14. #14
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,656

    Re: UserForm changing size from one computer to another

    I think the common solution is to build userfoms in various sizes and choose one based on the monitor resolution, which you can query via Windows API.

    That's a lot of work, though, and an alternative might be to make it as compact as possible, and adding a vertical scroll if necessary to make all of the controls accessible.
    Entia non sunt multiplicanda sine necessitate

  15. #15
    Forum Contributor
    Join Date
    09-10-2008
    Location
    Phoenix, AZ
    MS-Off Ver
    Office 365
    Posts
    748

    Re: UserForm changing size from one computer to another

    shg,

    Thanks for your reply - I have been noticing that a lot of folks claim to have a solution, yet none of them have been successful..

    I am afraid that your suggestion might be the Only Solution. This seems to be a long standing Issue... Maybe someone with VBA Savvy can finally figure a solution.

    Best Regards,

    John

  16. #16
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,656

    Re: UserForm changing size from one computer to another

    You're welcome, good luck.

  17. #17
    Forum Guru
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,032

    Re: UserForm changing size from one computer to another

    http://www.pcreview.co.uk/threads/us...uters.2783179/

    Please Login or Register  to view this content.

+ 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. How Small Function works when small(array,1),small(array,2) are same ?
    By bkvenkat in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 06-02-2015, 02:00 AM
  2. [SOLVED] Ranking from small to big not big to small ?
    By makinmomb in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-05-2014, 01:01 PM
  3. Functions similar to SMALL or overcome limitations of SMALL
    By arvindtechie in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-05-2013, 10:59 AM
  4. Replies: 4
    Last Post: 09-27-2010, 05:20 AM
  5. Small if+and
    By mitelkm in forum Excel General
    Replies: 1
    Last Post: 09-22-2009, 10:53 AM
  6. [SOLVED] Using Small
    By PH NEWS in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-27-2006, 04:30 AM
  7. [SOLVED] Small
    By tom in forum Excel General
    Replies: 2
    Last Post: 07-11-2006, 01:35 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