+ Reply to Thread
Results 1 to 4 of 4

Excel 2010 - VBA Userform - How to open a form starting at the top of the form

  1. #1
    Registered User
    Join Date
    09-07-2012
    Location
    Australia
    MS-Off Ver
    Excel 365
    Posts
    51

    Excel 2010 - VBA Userform - How to open a form starting at the top of the form

    Hi there,
    Thank you for taking the time to check this out

    I have a 2 multi-page form with scrollbars on each page.

    My problem is that when I open the form, it displays the middle of the form, meaning that I have to scroll up to view or data enter at the beginning of the form, which is very irritating for the user.

    I have searched high & low on the net, but haven't been able to find a solution. I have checked the properties of the Userform, the Multi-page, and all appears correct.
    Userform Properties from Security Incident Tracker - New V001.JPG

    The code I have relating to the scrollbars is:

    Please Login or Register  to view this content.
    I'd really appreciate any help you may have to fix this irritating problem.

    Cheers,
    TheShyButterfly

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Excel 2010 - VBA Userform - How to open a form starting at the top of the form

    Hello theshybutterfly,

    It would be best if you can post a copy of the workbook.

    Please redact any personal or confidential information before you post the workbook.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  3. #3
    Registered User
    Join Date
    09-07-2012
    Location
    Australia
    MS-Off Ver
    Excel 365
    Posts
    51

    Re: Excel 2010 - VBA Userform - How to open a form starting at the top of the form

    Thanks Leith ... hopefully this will help ...
    https://www.dropbox.com/sh/pmc361fqb...jUS3Xg4aa?dl=0

    Just another thing, whilst I think of it, could you also help me out by providing a code so that the user can resize the form using the mouse. I found a code, but it wasn't very helpful and my adaptation didn't work.

    Thanking you in advance
    Cheers,
    ShyButterfly

  4. #4
    Registered User
    Join Date
    09-07-2012
    Location
    Australia
    MS-Off Ver
    Excel 365
    Posts
    51

    Re: Excel 2010 - VBA Userform - How to open a form starting at the top of the form

    Thanks Leith ... hopefully this will help ...
    https://www.dropbox.com/sh/pmc361fqb...jUS3Xg4aa?dl=0

    I have also tried to attach it below (it's just under 300 kb) in case one or the other don't work.

    Just another thing, whilst I think of it, could you also help me out by providing a code so that the user can resize the form using the mouse. I found a code, but it wasn't very helpful and my adaptation didn't work.

    Thanking you in advance
    Cheers,
    ShyButterfly
    Attached Files Attached Files

+ 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. Excel 2010 - Userform - Vlookup, Alpha Numeric auto increment, send form to Outlook
    By theshybutterfly in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-24-2015, 05:54 AM
  2. Excel VBA - Step Into with F8 starting in Form.Show
    By trizzo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-03-2013, 04:07 PM
  3. loading userform form open
    By northernstar197 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-08-2007, 08:08 AM
  4. Starting a 'floating' form once a spreadsheet is open
    By den1s in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-03-2006, 09:09 PM
  5. How do you display a VBA user form when starting excel workbook?
    By dant in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-13-2005, 08:06 AM

Tags for this Thread

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