display top line of textbox in form as default?!?!?!

J

Juan Pablo González

MrExcel MVP

Joined

Feb 8, 2002

Messages

11,959

• Sep 19, 2003

• #2

Take a look at the SelStart property of the TextBox.

 

Upvote 0

N

nodding dino

Board Regular

Joined

Aug 5, 2003

Messages

94

• Sep 19, 2003

• #3

i don't seem to be able to find that property...?!?!?

 

Upvote 0

J

Juan Pablo González

MrExcel MVP

Joined

Feb 8, 2002

Messages

11,959

• Sep 19, 2003

• #4

You can access it by code:

Code:

Private Sub UserForm_Initialize()
    TextBox1.SelStart = 0
End Sub

 

Upvote 0

N

nodding dino

Board Regular

Joined

Aug 5, 2003

Messages

94

• Sep 19, 2003

• #5

nice one!

 

Upvote 0