none
Userform Textbox Position based on Textbox above RRS feed

  • Question

  • Is it possible to control the position of one Userform TextBox based on the Height of the TextBox above.

    My Userform will have a Number of Auto-sizing TextBoxes stacked above each other, however they overlap when autosize is on. I also have a column of Textboxes next to them which i would like to position at the top left  of each textbox as it moves

    Friday, March 8, 2019 4:08 PM

Answers

  • For example:

        Me.TextBox2.Top = Me.TextBox1.Top + Me.TextBox1.Height + 6

    6 will be the distance between the text boxes in points, where 72 points = 1 inch. You can change this number of course.


    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    • Marked as answer by Stirlingmw Saturday, March 9, 2019 10:44 PM
    Friday, March 8, 2019 5:36 PM

All replies

  • For example:

        Me.TextBox2.Top = Me.TextBox1.Top + Me.TextBox1.Height + 6

    6 will be the distance between the text boxes in points, where 72 points = 1 inch. You can change this number of course.


    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    • Marked as answer by Stirlingmw Saturday, March 9, 2019 10:44 PM
    Friday, March 8, 2019 5:36 PM
  • Awesome, Thank you.
    Saturday, March 9, 2019 10:44 PM