Hello John,
When I select one by one item (From CB1 to CB4) it work fine. But, When I go back to select another item in previously selected combobox, I get the error msg.(Run-time eror '1004').
Except that, your code works, perfectly. The way, I expected. Could you please fix this ?
Thank you very much.I appreciate your time and effort.
p_nayak268
Hi p_nayak
Try the Code in the attached...
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
Hello John,
Perfect !! Solved.
Thanks a lot.
You're welcome...glad I could help. Thanks for the Rep.
Hello John,
I used your code in a slightly different way and I was wondering if you could help me make one tweak?
After I make the first selection on the userform, it filters as I want, however, when I go to the next combobox it gives me all the values in that column. Is there any way to make these unique? For example, in the original document if you pick 2013, then for month Jan shows up multiple times. Any easy way to prevent this and only have it show up once?
Any help would be greatly appreciated!
Hi laurentaylor
Welcome to the Forum!!!
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.
If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.
Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
p_nayak268 
Register To Reply
Bookmarks