ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Allow Bold & Italic in a textbox (https://www.excelbanter.com/excel-programming/367037-allow-bold-italic-textbox.html)

LookingGood

Allow Bold & Italic in a textbox
 
Hi,
I have created a UserForm with a text box called 'FreeText1'. This text box
allows the user to input large chunks of data.

Q1. The ability to highlight text either in bold or italic.
Q2. Save the data into a cell on a spreadsheet as it appears in the textbox
with bold or italic prints
Q3. Populate that cell information into a Bookmark in Word.

Can this be achieved..

Thanks

Tom Ogilvy

Allow Bold & Italic in a textbox
 
None of it is supported by a textbox on a userform. You might be able to
link a cell to a bookmark.

--
Regards,
Tom Ogilvy

"LookingGood" wrote in message
...
Hi,
I have created a UserForm with a text box called 'FreeText1'. This text
box
allows the user to input large chunks of data.

Q1. The ability to highlight text either in bold or italic.
Q2. Save the data into a cell on a spreadsheet as it appears in the
textbox
with bold or italic prints
Q3. Populate that cell information into a Bookmark in Word.

Can this be achieved..

Thanks




LookingGood

Allow Bold & Italic in a textbox
 
Thank you for your immediate response.

I thought it might be the case as I could not find any within the discussion
group.

by the way, how do one link a cell to a word doc bookmark, if I think it is?


Many Thanks

"Tom Ogilvy" wrote:

None of it is supported by a textbox on a userform. You might be able to
link a cell to a bookmark.

--
Regards,
Tom Ogilvy

"LookingGood" wrote in message
...
Hi,
I have created a UserForm with a text box called 'FreeText1'. This text
box
allows the user to input large chunks of data.

Q1. The ability to highlight text either in bold or italic.
Q2. Save the data into a cell on a spreadsheet as it appears in the
textbox
with bold or italic prints
Q3. Populate that cell information into a Bookmark in Word.

Can this be achieved..

Thanks





Tom Ogilvy

Allow Bold & Italic in a textbox
 
I would look at Edit =Paste Special = Paste as Link for whichever
direction you are going.

--
Regards,
Tom Ogilvy

"LookingGood" wrote in message
...
Thank you for your immediate response.

I thought it might be the case as I could not find any within the
discussion
group.

by the way, how do one link a cell to a word doc bookmark, if I think it
is?


Many Thanks

"Tom Ogilvy" wrote:

None of it is supported by a textbox on a userform. You might be able to
link a cell to a bookmark.

--
Regards,
Tom Ogilvy

"LookingGood" wrote in message
...
Hi,
I have created a UserForm with a text box called 'FreeText1'. This text
box
allows the user to input large chunks of data.

Q1. The ability to highlight text either in bold or italic.
Q2. Save the data into a cell on a spreadsheet as it appears in the
textbox
with bold or italic prints
Q3. Populate that cell information into a Bookmark in Word.

Can this be achieved..

Thanks








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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com