I read an article lastnight by Frank Rice about MS object model programming. It contained info about userforms which I have shyed away from until now as I didn't know how they worked. I have a need to use one now as I suspect they will be cleaner and more efficient than combo boxes and data validation lists on the sheets (which are doing funny things like moving around the page or point blank refusing to work, I don't know why!).

My Question is how exactly do I get a combo or list box to work in a userform. I want to be able to populate the combo box in the userform with five named cells, job1, job2, job3 etc. I then want to be able to select the "job" that I want from the list in the combo box and have the procedure in the macro input that value into a cell in the destination workbook and hide the combo box.
Roger W