Just in case you come across a phenomenon your UserForm hangs Excel, you might want to runt the below code to eliminate all Alt+Enter entries on your sheet [that is Chr(10)], what is a new row initiation within a cell.
Cause that is what hangs Excel when a control of a UserForm wants to pick the equivalent character from the cell. 

Please Login or Register  to view this content.
Stay tuned
Cheers, Gabor