userform textbox scrollbar behaviour

[ashleywanless]

hi,

I have built a userform with several textboxes which show data, the data is never amended or input, its read from a sheet. I have set the textbox scrollbars property to 2 (fmscrollbarsvertical).

When my form loads the scrollbars do not appear until a user clicks on the textbox, i would like them to all appear constantly, is this possible?

Also when i do click in a textbox with a scrollbar this then jumps to the bottom of the data in that textbox, is it possible for this to jump to the start?

thanks

 

[mikerickson]

Or

With txtQuery
        .ScrollBars = fmScrollBarsBoth
        .EnterFieldBehavior = fmEnterFieldBehaviorRecallSelection
        ' Set the value
        .Value = q
       
        .SetFocus
        .CurLine = 0
End With