Well yes. You need a reference to the Microsoft Forms 2.0 Library. If you
manually put a control from the control toolbox toolbar on the worksheet,
you will have such a reference. Otherwise, in the VBE, go to
tools=References and find the above entry and click the checkbox.

--
Regards,
Tom Ogilvy



"jay" wrote in message
...

Hello Tom,

Thank you very much for the code, and I must say I am impressed with
the compactness of it.

However, I get a compiler error of: "User-defined type not defined"
This error, which gets 'blue' colored by the compiler is:

scrBar As MSForms.ScrollBar 'note: Dim is in front of this, just
wanted to show the 'blued' part herein

Am I supposed to put something in cell A5 ?

Am I supposed to add in something under "Tools' - Reference ?

Thanks for any input you can provide.

jay


--
jay
------------------------------------------------------------------------
jay's Profile:
http://www.excelforum.com/member.php...fo&userid=2377
View this thread: http://www.excelforum.com/showthread...hreadid=536928