Scrollbars not appearing for userform textbox

[MLDeS]

The problem:

I have a textbox and a listbox on a user form. When the user clicks on an item in the listbox the description of that item will appear in the textbox (done by VBA). When the text in the description textbox is longer than the box can display, the vertical scrollbar does not appear until the user clicks on the box to position the cursor in it.

I have set the scrollbars property of the textbox to ScrollBarsVertical, WordWrap and MultiLine to True in the VBA editor. The code that populates the box is effectively

        Form.DescriptionTextBox.Locked = False
        Form.DescriptionTextBox.Text = Description
        Form.DescriptionTextBox.ScrollBars = fmScrollBarsVertical
        Form.DescriptionTextBox.Locked = True

The line "Form.DescriptionTextBox.ScrollBars = fmScrollBarsVertical" seems to have no effect, whatever I set the scrollbars to doesn't seem to change the effect described above. I even tried setting the selection to the last part of the box contents briefly to make it scroll downwards and then setting it back to the top, and that didn't work either.

If I can't fix this behaviour of textboxes, should I be using a different control or just living with the problem?

 

[MLDeS]

Never mind, duplicate question- for anyone else looking the solution that worked for me (Form.DescriptionTextBox.SetFocus followed by Form.ListBox.SetFocus with appropriate visibility checks etc.) was earlier given at http://www.mrexcel.com/forum/showthread.php?t=287238&highlight=scrollbar+textbox

 

[dwsteyl]

Thank you MLDeS - I just had the exact same problem. Thank you for posting the solution you found!