Is it possible to have Rich Text capable Word Processing in an Excel Sheet?

[Stevet78910]

Pretty much the whole question in the title.

I'm trying to build a checklist where if a user selects a checkbox, text is added to a textbox or cell. However, I would then like to allow users to alter and edit that as if with a standard word document.

Ultimately, I would then like to be able to 'build an email' (probably via button macro) that collects each of these textboxes into a single large cell or textbox in order to cut & paste into outlook to send.

Is this even possible?


Thank you very much.

 

[Stevet78910]

Bump.

The reason I ask is because I thought I saw someone doing this once, editing text inside an Excel spreadsheet, however I cannot seem to find out how.

 

[Stevet78910]

Well, I suppose the answer is yes, I was able to create a textbox in Word, then cut&paste the box into an Excel sheet. It's entirely editable.

Now I am working on a way to make it so that it's already filled with text, but when you click the checkbox, some of the text will be removed.
Ex: A checkbox for "All Conditions Fulfilled". The textbox would already have "Some conditions are not fulfilled." written into it. When the user checks the box, the words "Some conditions are not fulfilled." will be removed. If the user never checks the box, the user could then go in and edit the line in order to specify which conditions remained.