Hi
Thanks to the help of this fórum I almost have one Project finished ... it only rest me one thing that suponse to be easy but it isn't. I been able to charge correctly the combobox at the user form, no matters what values are at the cells.
For the sheet I try to use data validation but for name ranges the spaces and special characters give me a lot of problems, also the lmitiation of range names and use of indirect with dinamyc ranges (OFFSET etc.) gives me a lot of problems.
Is there any way to include some code at the sheet to avoid dropdown lists at the first four columns at sheet data similar to that conform the combobox? I means values into sheet Data for col A and B are from sheet Pruebas and C and D from Mutuas. Also B depends on A and D on C. I only gets for the first column (see code for Sheet data) but I don't know how to do for the dependent column.
I upload a file with the user form and the data sheet.
Bookmarks