Solved: create notepad

[av8tordude]

Is it possible to insert/create a notepad (scratch pad) on a userform so I can copy and paste information to it?

[Paul_Hossler]

Sort of like a scratch pad

Paul

[mbarron]

You can use a RichTextBox control.

I used this method (Excel 2007)
While in form design, right click in the toolbox and choose Additional Controls...
Select Microsoft Rich Textbox Control 6.0 (SP4)

I ran into a problem when trying to add the control to the form. I got an error stating "subject is not trusted for the specified action". I was able to overcome the 'error' by changing the following Registry setting " HKEY_LOCAL_MACHINE\Software\Microsoft\Internet Explorer\ActiveX
Compatibility\{3B7C8860-D78F-101B-B9B5-04021C009402} " to 0 (zero)

The registry change was based on information found here -