I have a list with level 5 & level 7 info
I load level 5 on a listbox on a userform. I have a button that changes the listbox to single select. Then I want a selection to on show the level 7 options for that option. I know the code has to somehow count the rows to the next number 5, but to put it together is a bit tricky for me.
Can anyone help. I have attached my file.
Last edited by CobraLAD; 04-26-2015 at 02:09 PM.
Perhaps have a look on Pivot Table
Can you show what you want as result
- Battle without fear gives no glory - Just try
If main listbox is set to single select, I want to click on OPTION 4 and it must show me all Option 4 - Sub Options which in this case is 7 in the second listbox. If I click on OPTION 7 it then must show all Option 7 - Sub Options which is 16
Try this in the userform Module:-
Please Login or Register to view this content.
Thanks MickG it works 100% for this because all sub option has a "-", but my sub options is not always going to have "-".
maybe it can use the "7" in column A
Try this:-
Please Login or Register to view this content.
Thank you Mick, this works
You're welcome
For info another way I figured out
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks