Hi there
I'm new on this forum and vba and I don't speak English as well as I must but I hope you can understand my question. It's a boss asking and I must figured out how to solve.*
At the Model file I have two pages:
1. Call "Data" in which I have a database stored onto a Table (call Table1") with 11 columns*
2. Call "Lists" when I store de list and name range I use
Also I created a userform to search into the database with 5 combo box (the last with a default value).* The values of combo 2 depends on combo1 select and also for the combo 4 to combo 3.* Also I charged the database into the listbox called Results. The data from the combos are, in order the 5 first columns.*
I try to obtain:
- Filter / search the result on the listbox when you assign values at the para of combos *
- Using horizontal name range to populate combos 2 and 4 (it show me only the first value so I must select vertically cells).*
- Disable the combos 2 and 4 while you don't get a value at combo 1 (for combo 2) or 3 (for combo 4)
- Show only the columns 6 to 11 from Table1 at the listbox
I go thriough a lot of model codes from web by because I don't understand it all of it I can't addapted or know where the error is. I'm learning but I must to do this work for this week and I can't reach it in a week alone by now.
I upload an example file with this parameters if that helps.
Any help or reference or explanation will be appreciated*
Bookmarks