Hi
I am trying to write code that will populate my ListBox when a cell, named "FilterCell" changes
I have a list of companies, named range "Comp", that expands / reduces with whatever value is entered in "FilterCell"
May I ask for assistance with the code I have written so far -
Much appreciated!
Please Login or Register to view this content.
Try this...
Though I don't fully understand. If the ListFillRange is assigned to a named range, then whenever the named range changes, the list will automatically update. So I don't think you would need this code. As it always assigns the same named range to the listbox.Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Please Login or Register to view this content.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks