Run-time error '9':
Subscript out of range

Highlights within the Private Sub cmdOK_Click():
Worksheets(Me.ComboBox1.Value).Activate


It is telling you that the value of ComboBox1 does not equate to a
recognizable object. If you step through the code, using F8 key, to check
the code line by line your tool tips popup will show the values of your
objects and variables when you mouse-over them. Set a breakpoint on the
first line of the code after the title line and then click the button to
initiate the code. Then you can use F8 to step through the rest of the macro.

I will take a closer look at your other problem and see if I can find
something that I might have overlooked initially. Right now, I don't
understand why it is not working with the changes I gave you.