Solved: Insert text from last row

[av8tordude]

Can someone assist with a code that will insert the text from the last used cell in column "G" into a userform combo box.

example: if the last cell in column G has the word "Android", insert "Android" into combobox1

Thank you for your help

[av8tordude]

I found it..thanks

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

[av8tordude]

how can I only look at rows G11:G250 using this code?

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

[GTO]

If you are saying that you have other 'stuff' below row 250 in Col G, you'll want to use .Find

[av8tordude]

There is no other "stuff" below 250, but I have "stuff" above G11. I just want to search between row G11 & G250, if I have nothing in those cell, then textbox1 should not have a value.