+ Reply to Thread
Results 1 to 4 of 4

VBA Userform code and starting position

  1. #1
    Registered User
    Join Date
    01-22-2014
    Location
    Latvia
    MS-Off Ver
    Excel 2010
    Posts
    2

    VBA Userform code and starting position

    Hello, i would like to ask for some help with excel userform. I made the userform but dont know exact code for it, and would like to know how to set the entry position for each field. I made an example file. Normally it posts on the top of the page, but i would like to change the position, as shown in the example file.
    Thank you in advance!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: VBA Userform code and starting position

    Hi

    Unfortunately it isn't very easy.

    There are a few things to make it simpler.

    You can select multiple controls by clicking shift and left click together.

    Now if you right click you have align options left, right, top, bottom.
    Size options same hieght, width, both.

    Group options.

    Have Fun

  3. #3
    Registered User
    Join Date
    01-22-2014
    Location
    Latvia
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: VBA Userform code and starting position

    Thanks for answer. Where exactly i need to use shift + left click? In VBA or in worksheet?

  4. #4
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: VBA Userform code and starting position

    Within the userform

+ 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 to code a userform to take average of row starting and ending at selcted dates
    By teacher_rob in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-27-2011, 11:54 AM
  2. Fixing position of Userform
    By maximpinto in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 10-06-2009, 06:13 AM
  3. Starting Userform
    By Mats Samson in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-29-2005, 06:05 AM
  4. Position of a UserForm
    By MD in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-11-2005, 08:06 PM
  5. 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