PC Review


Reply
Thread Tools Rate Thread

Edit Cell's content into a larger box (Rich text box)

 
 
Alex
Guest
Posts: n/a
 
      6th Jun 2008
Hi !
I'm wondering if there is a way to edit an excel cell's content into a
larger box ?

The text inside the cell is for word paragraphs and it can be quite long. To
insert a new paragraph, the user press Alt-Enter in excel.

Is there a way to make a macro (like shortcut Ctrl-E) that will open a form
or create a temporary text box with the drawing toolbar that will allow the
user to edit the content (with rich text format if available).

Also, it should be nice if we could add example of paragraphs that will vary
depending of the question. (I'll copy all paragraph example into vba). So the
user could make a copy-paste of the example to add it directly in the large
box and press OK to save the contents into the cell.

Thank you!

Alex

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I get bullets to appear when I use the rich text content c. Oakely Microsoft Word Document Management 2 4th Jan 2010 07:37 PM
Printing cell's content larger than cell width Neophyte Microsoft Excel New Users 1 14th Oct 2007 09:20 PM
text from rich edit Chris Bubel Microsoft Dot NET Framework 0 23rd Nov 2005 06:31 PM
inserting text at mouse position in text or rich edit box =?Utf-8?B?SGVuZHJpaw==?= Microsoft C# .NET 2 11th Nov 2004 06:35 PM
A rich text edit control? Simon Harvey Microsoft Access 3 6th Aug 2003 06:15 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:30 PM.