PDA

View Full Version : Solved: Insert text from last row



av8tordude
05-02-2011, 07:20 PM
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
05-02-2011, 08:24 PM
I found it..thanks

Me.textbox1= Range("G250").End(xlUp).Value

av8tordude
05-02-2011, 10:23 PM
how can I only look at rows G11:G250 using this code?

textbox1= Range("G250").End(xlUp).Value

GTO
05-02-2011, 11:58 PM
If you are saying that you have other 'stuff' below row 250 in Col G, you'll want to use .Find

av8tordude
05-03-2011, 02:08 AM
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.