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
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.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.