I would like to now how can I do the following:



I have a workbook with several worksheets (Results, Def01, Def02, Def03 and
Def04), each sheet "Def0X" have in the column B a list of data for witch I
have attribute a range name.



I have made a UserForm to help me inputting data in the worksheet "Results".
In the UserForm I have used some 4 ComboBox to load the lists that are in
the worksheets "Def0X"



My questions are:



1- How can I load the lists in the ComboBox using the range name method?



2- When the data field in the ComboBox don't exist in the list, how can I
update the list automatically by updating the range Name address?