No the If/Then code should basically be removed from where it is as they write directly to CandidateTemp.

Where it belongs, and probably in a different form, is in the code that transfers the candidate data to a form.

1 Yes that needs to be done.

2 The print Selected button does work, the print All button just needs this line uncommented.
'ws.PrintOut