I found it..thanks

[VBA]Me.textbox1= Range("G250").End(xlUp).Value[/VBA]