+ Reply to Thread
Results 1 to 4 of 4

Recall User Form Position

  1. #1
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,014

    Recall User Form Position

    .

    Haven't been able to locate many examples on the internet and absolutely nothing on the forum regarding saving the position of a User Form for reload.

    This macro is seen on several websites :

    Please Login or Register  to view this content.

    However ... it isn't working here.

    What am I doing wrong ?
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    04-01-2013
    Location
    East Auckland
    MS-Off Ver
    Excel 365
    Posts
    1,343

    Re: Recall User Form Position

    set startupposition to manual (0) in the properties of the form
    If you want something done right... find a forum and ask an online expert.

    Time flies like an arrow. Fruit flies like a banana.

  3. #3
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Recall User Form Position

    your StartupPosition was set to CentreOwner (or 1)
    either hard code it to 0 via the settings OR add the line in like below

    Please Login or Register  to view this content.
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  4. #4
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,014

    Re: Recall User Form Position

    .

    scottiex

    Dang ! That did the trick. Too bad it was not mentioned in the few examples on the net that I found.

    Thank you sir !!!

+ 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. [SOLVED] Recall the data as it is in the user form to edit and update
    By bala04msw in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-29-2018, 02:15 PM
  2. [SOLVED] Position a User Form on the Screen
    By dflak in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 07-16-2018, 04:27 PM
  3. User Form Startup Position
    By ldoodle in forum Outlook Programming / VBA / Macros
    Replies: 0
    Last Post: 07-11-2018, 06:25 AM
  4. [SOLVED] Copy data from fillable user form to database tab in column format/recall past records
    By johnstevens in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 06-13-2014, 01:28 PM
  5. User form on initialize to recall last entry from Excel Sheet
    By maip.kewa in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-04-2014, 07:16 PM
  6. Start Up position of User Form
    By Shazz in forum Excel General
    Replies: 3
    Last Post: 03-07-2012, 12:54 PM
  7. [SOLVED] Recall function to a User Form
    By shnim1 in forum Excel General
    Replies: 1
    Last Post: 04-12-2006, 02:47 AM

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