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) -
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.