I have two columns in my Workbook, Dept (Column M) & Team (Column N) ...
Dept with Data Validation =INDIRECT("Dept") ie pointing at the Named Range = Dept
Team with Data Validation =INDIRECT(SUBSTITUTE(SUBSTITUTE(M1161," ",""),"&","")) ie pointing at the Named Range = the selection made in M1161/Dept (with any spaces or commas stripped out)
I now want to emulate this in a UserForm/VBA behind the two ComboBoxes ...
But I can't get out to work!
Any ideas please?
Dept with Data Validation =INDIRECT("Dept") ie pointing at the Named Range = Dept
Team with Data Validation =INDIRECT(SUBSTITUTE(SUBSTITUTE(M1161," ",""),"&","")) ie pointing at the Named Range = the selection made in M1161/Dept (with any spaces or commas stripped out)
I now want to emulate this in a UserForm/VBA behind the two ComboBoxes ...
But I can't get out to work!
Any ideas please?