Consulting

Results 1 to 4 of 4

Thread: How to line up input boxes on forms?

  1. #1

    How to line up input boxes on forms?

    I have a pretty large form with dozens of input boxes - I need to lay these out consistently.

    Does anyone know of a tool which draws gridlines or helps with positioning form fields?

  2. #2
    Administrator
    VP-Knowledge Base
    VBAX Grand Master mdmackillop's Avatar
    Joined
    May 2004
    Location
    Scotland
    Posts
    14,489
    Location
    Are these on a Spreadsheet or a Userform? Do you have any naming convention for them?
    MVP (Excel 2008-2010)

    Post a workbook with sample data and layout if you want a quicker solution.


    To help indent your macros try Smart Indent

    Please remember to mark threads 'Solved'

  3. #3
    this is on a user form - I have a naming convention but I am not sure how that would help.

    Is snap to grid available????

  4. #4
    Mac Moderator VBAX Guru mikerickson's Avatar
    Joined
    May 2007
    Location
    Davis CA
    Posts
    2,778
    In the VBEditor, there are options under the Format menu item that could help you at design time. Also under File>Preferences>General you can set the size of the Grid and there is a Align Controls to Grid checkbox.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •