I have a UserForm with TextBox and a vertical scrollbar. Text is appended to the textbox in the following way:

```
 UserForm1.TextBox1.Value = UserForm1.TextBox1.Value & "**Opened file " & i & "**" & vbNewLine

```

When there is too much text to show, the scrollbar doesn't scroll down to show the added text. I need to see that text in the process of the macro running.

I tried

```
UserForm1.TextBox1.CurLine = -1

```

and

```
UserForm1.TextBox1.CurLine = UserForm1.TextBox1.LineCount-1

```