PDA

View Full Version : Solved: textbox.SelStart Excel 2004 no effect?



tpoynton
07-29-2007, 07:46 AM
follow up to this post (http://vbaexpress.com/forum/showthread.php?t=14014) , where a sample workbook is provided.

while no error is presented, nothing happens. tried changing the value to 1, 10, and 100 with the same result...

the property is listed in VBA help on mac, so it's curious that it doesnt seem to work...

tpoynton
07-31-2007, 06:53 AM
OK, found the answer and a better way to set a multiline textbox to the first line that works on both mac and PC platforms...


With TextBox1
.SetFocus
.CurLine = 0
End With


the curline property is listed in VBA help...just didnt find it soon enough:)

Bob Phillips
07-31-2007, 11:44 AM
Thanks for posting your solution Tim, that was an interesting little problem.