+ Reply to Thread
Results 1 to 7 of 7

Specifying UserForm Position

  1. #1
    Forum Contributor
    Join Date
    04-22-2016
    Location
    Philippines
    MS-Off Ver
    2016 & Office365
    Posts
    139

    Post Specifying UserForm Position

    How to align or reposition userform base on current cell location.
    The [menu] button aligned the way i want and when [menu] button click
    i want the userform show beside [menu] button too.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor dotchiejack's Avatar
    Join Date
    05-21-2015
    Location
    Antwerp,Belgium
    MS-Off Ver
    2016
    Posts
    507

    Re: Specifying UserForm Position

    Hi,
    Like this?
    Please Login or Register  to view this content.
    Click the * Add Reputation below to say thanks.

  3. #3
    Forum Contributor
    Join Date
    04-22-2016
    Location
    Philippines
    MS-Off Ver
    2016 & Office365
    Posts
    139

    Re: Specifying UserForm Position

    Thanks for quick reply sir, but work only when you are on top rows of sheet.
    If you go down, like if you go to row 50 then userform didn't show beside menu button...

  4. #4
    Forum Contributor
    Join Date
    04-22-2016
    Location
    Philippines
    MS-Off Ver
    2016 & Office365
    Posts
    139

    Re: Specifying UserForm Position

    i'm using below code, but how can i make userform to stay beside [menu] button always.
    Please Login or Register  to view this content.

  5. #5
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,411

    Re: Specifying UserForm Position

    See 'Chip Pearsons' site, without a lot of complex code there does not seem to be an easy answer.
    torachan.

  6. #6
    Forum Contributor
    Join Date
    04-22-2016
    Location
    Philippines
    MS-Off Ver
    2016 & Office365
    Posts
    139

    Re: Specifying UserForm Position

    I already checked Chip Pearson site/samples but it didn't goes the way i want...

  7. #7
    Forum Contributor
    Join Date
    04-22-2016
    Location
    Philippines
    MS-Off Ver
    2016 & Office365
    Posts
    139

    Post Re: Specifying UserForm Position

    Could anyone check this one, i tried but working only if columns width are the same.
    userform is adjusting position if column width are different to others...
    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. Position userform below a shape
    By JasperD in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-16-2015, 08:23 AM
  2. Dynamic userform position based on widow position
    By Manish84 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-16-2015, 07:47 AM
  3. Userform position
    By calvinle in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-15-2014, 08:36 AM
  4. Fixing position of Userform
    By maximpinto in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 10-06-2009, 06:13 AM
  5. Display position of Userform
    By AndyRoo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-06-2005, 11:35 AM
  6. Position of a UserForm
    By MD in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-11-2005, 08:06 PM
  7. [SOLVED] Re: Userform Position
    By bobkaku in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-19-2005, 08:06 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