Originally Posted by Charles Kenyon

Graham is the expert on Userforms, I'm just a novice myself, especially compared to him. If you have not already done so, I recommend strongly that you review Graham's written tutorials. Create a Simple Userform is the one with document variables.

For a different take, look at this one, too. Create & Employ a Userform

Both Graham Mayor and Greg Maxey know far more about this stuff than I do. I have successfully used UserForms by following their instructions. That is how I knew to ask the questions I did.

BTW, renaming that button cmdOK would make it easier to follow the code, at least for me. I tend to write these things and get them to work, then not look at them again for years.