PDA

View Full Version : Solved: create notepad



av8tordude
04-04-2011, 01:59 PM
Is it possible to insert/create a notepad (scratch pad) on a userform so I can copy and paste information to it?

Paul_Hossler
04-04-2011, 07:28 PM
Sort of like a scratch pad

Paul

mbarron
04-04-2011, 08:04 PM
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 (http://groups.google.com/group/microsoft.public.office.developer.vba/browse_thread/thread/3ef04a2f2a8cef1e/76252635e022bb41) -