Currently I have a book that has a combobox inside a usermodule.
The row source is set to Sheet1!E2:E12
E2:E12 all have values in them...
Let's say I add something to E13.. How can I get the rowsource to automatically include E13 without me having to manually update it every time?
Hello,
Go to 'Name Manager' in 'Formulas' tab. Create new: Set Name exa. "List" then copy below code in "Refers to:"
Then goto your userform, select the combobox, set "=List" in 'RowSource' property.
=OFFSET(Sheet1!$E$2, 0, 0, COUNTA(Sheet1!$E:$E)-1,1)
That's it.
or in your UserForm
Private Sub UserForm_Initialize() Dim lRow As Long lRow = Sheets(1).Range("e53556").End(xlUp).Row Me.ComboBox1.List = Sheets(1).Range("e1:e" & lRow).Value End Sub
blue
Blue, I'll give that a little jot in my notebook and try that also. Never a bad thing to know how to do something multiple ways. Thanks!
I had to change
to=OFFSET(Sheet1!$E$2, 0, 0, COUNTA(Sheet1!$E:$E)-1,1
Because with the -1 near the end, it took the last one of the list out. So if I had the list 1,2,3,4,5... The -1 only made it show 1,2,3,4... But either way, it worked well enough for me=OFFSET(Sheet1!$E$2, 0, 0, COUNTA(Sheet1!$E:$E)+1,1)Thank you!
Good !
You can set this tread as [Solved].
Hello rybussell,
thx for the feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks